best performance in datasource

04-16-2009 2:45 AM |

Hi,

 I am new to SliverLight. Can any one please tell me which is the best amonth the linq, DataSet ( Dynamic generated columns and rows), and separate classes.

Data will be retrieved from different tables and connecting through the diff tables. i am use dynamic sql statement and retrieving the data.

Could please help any one in this

 Thanks

Ramakrishna

Re: best performance in datasource

04-16-2009 4:39 AM |

thanks for you reply.

i need somthing like previous version of dataset.

OpenConnection: connection string will be passed by dynamically.

Reading :

reading data will different types

reading fileds, and captions from a table and passing the values to the storedprocedure

here fieldinfo is in one table and data is in another table 

ex: 

QueryStr="[Fieldname] as [FieldCaption]"

tblName = "Table1"

spResults QueryStr,tblName

Re: best performance in datasource

04-23-2009 1:52 AM |

Hi Rama2009,

You are asking the performance issue.  I think dynamic sql and storedprocedure are ok.  The key point is the our table structure and cache mechanism.  Also, it is a huge topic.  We suggest that you'd better buy a book and take a look.

Best regards,

Jonathan