Looking for a .Net ORM

Posted by SLaks on Stack Overflow See other posts from Stack Overflow or by SLaks
Published on 2010-04-16T14:33:23Z Indexed on 2010/04/19 2:33 UTC
Read the original article Hit count: 451

Filed under:
|
|

I'm looking for a .Net 3.5 ORM framework with a rather unusual set of requirements:

  • I need to create and alter tables at runtime with schemas defined by my end-users.
    (Obviously, that wouldn't be strongly-typed; I'm looking for something like a DataTable there)
  • I also want regular strongly-typed partial classes for rows in non-dynamic tables, with custom validation and other logic. (Like normal ORMs)
  • I want to load the entire database (or some entire tables) once, and keep it in memory throughout the life of the (WinForms) GUI. (I have a shared SQL Server with a relatively slow connection)
  • I also want regular LINQ support (like LINQ-to-SQL) for ASP.Net on the shared server (which has a fast connection to SQL Server)
  • In addition to SQL Server, I also want to be able to use a single-file database that would support XCopy deployment (without installing SQL CE on the end-user's machine). (Probably Access or SQLite)
  • Finally, it has to be free (unless it's OpenAccess)

I'll probably have to write it myself, as I don't think there is an existing ORM that meets these requirements.
However, I don't want to re-invent the wheel if there is one, hence this question.

I'm using VS2010, but I don't know when my webhost (LFC) will upgrade to .Net 4.0

© Stack Overflow or respective owner

Related posts about orm

Related posts about c#