I'm new to connecting a database in C#. (But I'm familiar with admin'ing and
using several different SQL databases - mysql, postgres, MS in particular).
There are about a zillion possible options, it seems.
I'd like to know, generally, is there a specific thing I should be focusing on,
or foc
You're really describing an ORM that's capable of connecting to all the
back ends you want.
This would mean that you can stay away from anything too specific to any
one DB implementation.
For usage on both Linux and windows, I'd recommend NHibernate, however,
I'll caveat that by saying I've only
I would really recommend looking at the ServiceStack OrmLite as an ORM solution
that runs well under mono. Except for the cases where you need to write
DB-specific SQL (and these will likely come up so just learn to isolate them),
you will not need to deal with database specifics in your code:
On 2 Dec 2013, at 23:30, Martin Thwaites wrote:
> For usage on both Linux and windows, I'd recommend NHibernate, however, I'll
> caveat that by saying I've only really used that and entity framework (EF6 is
> available, but it appears to still be a bit buggy on none MSSQL/Windows
> machines).