Daynamic SQL in SilverLight

01-09-2009 4:51 PM |

Is SilverLight support Dyanamic SQl ? actually in sp i am using exec table so i don't get the  reference of sp in IService.cs so i want to know that Daynamic SQL don't support SilverLight?

 

Thanks

Re: Daynamic SQL in SilverLight

01-09-2009 6:31 PM |

 Can you please elaborate? Yes, you can use Linq to Sql to generate dynamic queries.

 

 

This post has some links which you might find useful.

 

http://silverlight.net/forums/t/64310.aspx

 

 

 

Re: Re: Daynamic SQL in SilverLight

01-09-2009 6:40 PM |

i am using a stored pocedure in which we pass multiple value of a column means there is column  CA which having more tahn one value like i am passing 'A,B,C' so i want to fetch data from passing theses Ca value.

and also pasing table name daynamically.so i create i temp table and using exec (Dynamic SQl).

now when i execute that procedure it works fine but when we want to take a reference in to

IUI_Service.cs firl  teh we are not able .so can u help me on this problem

Re: Re: Daynamic SQL in SilverLight

01-15-2009 2:09 AM |

Hi Rohitnegi09,

rohitnegi09:

now when i execute that procedure it works fine but when we want to take a reference in to

IUI_Service.cs firl  teh we are not able .so can u help me on this problem

 

We are a little confused by your description.  Generally, we use WCF or Web Service to communicate with the Database. In this condition, we call the procedure just as we did in normal aspx pages.  Please take a look at this video tutorial.

If I have something misunderstood you, please feel free to let me know with more information.

Best regards,

Jonathan