views:

428

answers:

4

Anybody found yet a good web site architecture using linq to sql? Any help will be very helpful!

+2  A: 

What, apart from StackOverflow? ;-)

Steve Morgan
is the source code available? :P
Bruno
+2  A: 

We just finished up an internal IT project banking heavily on Linq2Sql and it paid off. I was a bit skeptical at first, but I think it worked out great in the end. Just remember, the fundamentals don't change.

1) try to stay as stateless as possible 2) keep clean lines between your services and data access 3) don't fight linq, use it. If it isn't helping you, you are probably doing something wrong

Our implementation ended up being a hybrid of the Andrew Siemer and Beth Massi approach (a bit heavier on the Andrew side) and in C#

slf
+1  A: 

Remember Linq is a technology that sits atop the typical data access structures. Therefore all rules that have applied thus far still hold. Just because you can get to data a little easier in the client app doesnt mean you throw out the architecture best practices for data access.

Thomas Wagner
+1  A: 

Rob Conery's MVC Storefront

As others have said, linq-to-sql is no different to any other ORM so the architecture is the same as you would use for NHibernate and others.

liammclennan
I haven't looked too far into the code, but it looks like something that was thrown together in an evening. There's a SQL statements right in the index.aspx of the home page, and it's not even using Linq To SQL.
Kibbee
Rob's project would be using Subsonic rather then linq to SQL
Aaron Fischer