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
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