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 really used that and entity framework (EF6 is available, but it appears to still be a bit buggy on none MSSQL/Windows machines). I'd read up on ORMs before looking at the name spaces. Hope that helps. Martin. On Dec 2, 2013 8:03 PM, "Edward Ned Harvey (mono)" < [email protected]> wrote: > 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 focusing away from? In particular... There's all this > linq stuff that I don't fully understand... There seems to be a > "connection" namespace / assembly. System.Data.SqlClient... > System.Data.Linq... System.Data.Odbc... > > > > The goal is to support a server app, which will be supported on windows > server and various flavors of linux server. So we'd like to store and > manipulate data in whichever type of database the admin prefers to deploy, > which is likely to be MS, Mysql, Postgres, Oracle... I'd like to do as > little as possible by way of thinking about the database internals. I'd > like to, as much as possible, manipulate data structures (class hierarchy) > in memory, and use the database in the backend as transparently as possible > to the application developer (me). > > > > I admit I haven't looked into it much yet. I know the need is coming, I'm > trying to avoid going into it foolishly (but sometimes that's precisely > what's best to do.) > > > > Thanks for any wisdom... > > _______________________________________________ > Mono-list maillist - [email protected] > http://lists.ximian.com/mailman/listinfo/mono-list > >
_______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
