c# - Library for database (schema) management -

c# - Library for database (schema) management -

i looking .net library deed abstraction layer between application , database. application deals construction alterations, creating new table or adding column existing table.

i have library deals straight database entities tables, schemas or columns - not orm (unless orms have "utility" layer). back upwards postgresql , sql server required (oracle , sqlite "a nice have" feature).

any free or commercial (but royalty-free i.e. no per-server license) solutions much appreciated.

for dal, recommend nhibernate (http://nhibernate.info/) great all-rounder:

easy use

good abstraction

powerful features.

it gets improve fluentnhibernate (http://www.fluentnhibernate.org/)

--

if looking more speedy , light-weight, take @ stackoverflow's own dapper (https://github.com/stackexchange/dapper-dot-net)

c# .net sql-server database postgresql