Last post Sep 12, 2014 03:19 AM by Kevin Shen - MSFT
Sep 04, 2014 10:42 AM|dotnetfrenzyyy|LINK
I am .NET Developer of around 4 years of experience.
Linq to SQL feature introduced by Microsoft is definitely time saving and easy to use.
Infact Linq itself is charming feature (linq to sql ,linq to xml). But interacting with database is usual thing and using Linq to sql we can make it very easier.
I have observed in most of the companies Linq to SQL is not being used even though it reduces time and efforts of creating DAL , writing sql queries , writing stored procedures.
I have already used in two small project and its working fine.
Why companies following only traditional .NET architecture(DAL) instead of using Linq to SQL. Is there any drawbacks of Linq to SQL .Please let me know. Thanks in advance.
Thanks and Regards,
Sep 04, 2014 11:12 PM|Kevin Shen - MSFT|LINK
Here are some disadvatange given by the link below:
You can also refer to the link below which may give a right direction:
Below is link about comparsion between linq to sql and ado.net:
This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore,
Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you
completely understand the risk before retrieving any software from the Internet.
Sep 09, 2014 02:37 AM|dotnetfrenzyyy|LINK
Thanks for quick reply.
As you listed lots of disadvantages of Linq SQL now my questions are
1] i think may be this functionality is not suitable for Large Applications/Website am i right here?
2] in which applications Linq to SQL is much suitable?
3]as Microsoft introduced such a cool functionality how can we take maximum advantage as developer ?(i think we can combine Linq to sql and ADO .net in single Project is it efficient?).
Thanks in advance
Sep 10, 2014 01:48 AM|dotnetfrenzyyy|LINK
Please let me know if any one have idea of my questions.
Sep 12, 2014 03:19 AM|Kevin Shen - MSFT|LINK
In my opinion,Linq to Sql is more suitable for small or middle Application /WebStie.
Of course ,you can combine linq to sql and ado.net in a single project.