building an ASP NET MVC site, should i go with linq to sql?
Posted
by aspm
on Stack Overflow
See other posts from Stack Overflow
or by aspm
Published on 2010-04-07T18:16:00Z
Indexed on
2010/04/07
18:23 UTC
Read the original article
Hit count: 188
so i'm about to start a new website from scratch and i've spent about a week trying to figure out what technology to go with. i'm sold on ASP NET MVC. i'm 100% sure i'm going to love using that. but what i am not so sure about yet is using LINQ 2 SQL. so far i've gathered some data...
1) stack overflow uses it - can't be that bad 2) can be REALLY slow if you don't take advantage of compiled queries 3) will always be slower than ADO net, but can be almost just as fast if using #2 in the proper places 4) is NOT the preferred MS solution (there was a thread here on SO about dropping support)
i'm itching to use it, but just want to make sure it's the best for me. i come from a heavy ADO/stored procedure and traditional asp net background (this will be my first experience with ASP MVC).
© Stack Overflow or respective owner