Sign in

Microsoft.com

Microsoft

Remove From My Forums

SIlverlight 4.0 Linq2SQL querying a database to populate a quote

Question
0

Sign in to vote

I am trying to query a SQL database initially to populate a datagrid in silverlight using Linq2SQL, I know there are various threads on this e.g. http://www.c-sharpcorner.com/uploadfile/dpatra/silverlight-4-linq-to-sql-classes-in-vs-2010/

However I seem to get stuck at "Let's use the ServiceReference to get the Employee details." where this needs to go etc.

Does anybody have a link to an easy to follow tutorial that will allow me to get the data from SQLServer via Linq2SQL?

regards,

Matt

Friday, November 29, 2013 1:25 PM

All replies

0

Sign in to vote
Hello Matt,

Why do you need to do that using Linq2SQL. Event in case you will achieve your goal this code would not work for Online or IFD deployments. I would suggest you to use Linq2CRM. Sample.
Dynamics CRM MVP/ Technical Evangelist at SlickData LLC
My blog
- Proposed as answer by Andrii ButenkoMVP, Moderator Friday, November 29, 2013 7:16 PM
Friday, November 29, 2013 7:15 PM

Moderator
0

Sign in to vote

I need to query a separate SQL database in order to retrieve certain information which can then be used to populate a quote module within CRM, hence the first part of the app is to query SQL.

regards,

Matt

Monday, December 2, 2013 9:13 AM
0

Sign in to vote

Anyone got any pointers?

The SQL Database I need to connect to is version 2003 but I run into this error when trying to connect via entity framework:

http://social.msdn.microsoft.com/Forums/silverlight/en-US/d09adc11-c9c0-4371-9e87-4f5b053c7522/creating-an-entity-model-for-sql-server-2003?forum=silverlightarchieve#374ea87f-9f81-449a-b9d1-be14408e01fa

regards,

Matt

Thursday, January 2, 2014 10:03 AM