Hi,

Hope that I'm posting this in the correct form.

My project at work is using Linq to SQL classes and I am unsure as to why things have been implemented using this.

I've been reading a lot about Lint to SQL classes - seems that they can create performance issues. We have been having performance issues and I'm guessing it may be because of this.

Some questions:
1) Is Linq to SQL even a recommended tool to be using?
2) What are some options to using Linq?

Thank you.
Tulsi
-

Hi there,

>> Is Linq to SQL even a recommended tool to be using?

It depends. It's a bit dated and a more modern choice would be Entity Framework. However, one of the busiest sites on the internet, the StackOverflow family of sites uses Linq to SQL so it's certainly a viable choice. If you have performance problems it's likely in the implementation (large joins for example) and not in the framework itself.


>> What are some options to using Linq?

That's too broad a question to answer. I recommend you get some books or tutorials dealing with Linq to SQL and familiarize yourself with the technology and then come back here with specific questions.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!