building an ASP NET MVC site, should i go with linq to sql?
- by aspm
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).