StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I have experience with 3 ORM layers:</p> <ul> <li><a href="http://subsonicproject.com/" rel="noreferrer">Subsonic</a></li> <li><a href="http://www.lhotka.net/cslanet/" rel="noreferrer">CSLA.NET</a></li> <li><a href="http://nettiers.com" rel="noreferrer">.NET Tiers</a></li> </ul> <p>All three are free, support OleDb connections, and stored procedures.</p> <p>Subsonic - This one was built specifically for web applications. It mimics a lot of what Ruby On Rails does. They just added migrations. Subsonic is the lightest of the three. It's a tad harder to use for Winforms, but not as hard as I though it would be. It comes with a nice UI tool to generate the code and maintain database settings. This is the only one that has support for different databases. I've used it with SQLite, SQL Server CE, and SQL Server.</p> <p>CSLA.NET - This one can pretty much handle pretty much all of the new and shinny .NET technologies. I know that the author just added support for WCF, WPF, and Silverlight. This is what I use when I need very heavy lifting with enterprisey type apps. It has a lot of nice features like unlimited object undo, the ability to mark collections as read only, and the ability to move and anchor objects anywhere you want. This is the closest you will get to what JBoss does on Java.</p> <p>Net Tiers - I'm not a big fan, but it will get the job done. It's lighter than CSLA, but still heavier than Subsonic.</p> <p>I would to also mention <a href="http://www.hibernate.org/343.html" rel="noreferrer">NHibernate</a>, <a href="http://www.castleproject.org/activerecord/index.html" rel="noreferrer">Castle Active Record</a>, and <a href="http://www.codeplex.com/entlib" rel="noreferrer">Microsoft Enterprise Library</a>. I don't have much experience with these though.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload