Download Visual Studio 2008 and Sql Server 2005 for Linq Samples
Filed under: T-Sql to Linq Upgrade — admin @ 5:27 pm
If you newbie to linq, you should download and install some tools for trying samples and developing apps.
Visual Studio 2008 and Sql Server express editions:
We suggest that you should install Sql Server 2005 Express and Northwind database on it. Here is the link:
I have explored the LINQ to SQL class for my sample shopping cart application . What i felt is , LINQ to SQL is very easy to use and it consists very less code compare to earlier method. Also i used Stored procedures in it.
I need some clarification for this. Generally it writes SQL queries in behind the scene. User no need to write T-Sql and all . ok
My doubt is , which is the best performer in a run time whether LINQ to SQL or earlier method ?
So far i faced one drawback . i.e there is no dataadapter for this . In some case i used to maintain the resultant value of LINQ query in a datatable . i struggled there alone. otherwise very user friendly and less code for development.
suggest me .
Comment by Durai karthik — April 16, 2008@ 6:58 pm
You’re right. LINQ to SQL is very easy to use and consists less code.
I think developer don’t need to write t-sql except from some special cases.
I have some apps on facebook. I wrote most of them using previous method but I used Linq to Sql for the last one. I can get the same performance both from the old apps and the new one.
Comment by admin — April 17, 2008@ 1:18 pm
Thanks authors for the reality materials, a lot of the provocative advice. All good.
Comment by BomoSpone — July 3, 2008@ 6:41 am