Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>What you are asking for looks like an <a href="http://en.wikipedia.org/wiki/Object-relational_mapping" rel="nofollow noreferrer">Object-relational mapper</a> with LINQ provider.</p> <p>For instance, <a href="http://nhforge.org/Default.aspx" rel="nofollow noreferrer">NHibernate</a> ORM (my personal favorite) supports both PostgreSQL and MySQL. As of <a href="http://www.zvolkov.com/clog/2010/12/04/whats-new-in-nhibernate-3-0-ga/" rel="nofollow noreferrer">version 3.0</a> it has a built in LINQ provider.</p> <p>Microsoft's <a href="http://msdn.microsoft.com/en-us/library/bb399572.aspx" rel="nofollow noreferrer">Entity Framework</a> doesn't have out of the box support for many database engines, as NHibernate has, but there are <a href="http://msdn.microsoft.com/en-us/data/dd363565.aspx" rel="nofollow noreferrer">third party solutions</a>. Btw, EF <a href="http://weblogs.asp.net/scottgu/archive/2012/07/19/entity-framework-and-open-source.aspx" rel="nofollow noreferrer">got open-sourced</a> two days ago. </p> <p>There's an interesting site that compares various ORMs in .NET world - <a href="http://ormbattle.net/" rel="nofollow noreferrer">ORM Battle</a>. There you can find a list of other popular ORMs and see how they compare to each other.</p> <p>Some SO ORM questions:<br> <a href="https://stackoverflow.com/questions/132676/which-orm-for-net-would-you-recommend">https://stackoverflow.com/questions/132676/which-orm-for-net-would-you-recommend</a><br> <a href="https://stackoverflow.com/questions/3187928/best-orm-to-use-with-c-sharp-4-0">Best ORM to use with C# 4.0</a> </p> <p>Also, <a href="https://stackoverflow.com/questions/5829891/which-micro-orm-to-use">micro-ORMs</a> have recently risen in popularity. They don't really offer a full object to database mapping, nor Linq support (most of them) but they could be a good tool for the job.</p>
    singulars
    1. This table or related slice is empty.
    1. POAre there any third party libraries for using Postgresql or MySql with C# that allow direct object to database translation?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USMiroslav Popovic
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAre there any third party libraries for using Postgresql or MySql with C# that allow direct object to database translation?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThough there are _many_ other ORMs. Entity Framework, Dapper and more.
      singulars
      1. PO
      1. USOded
    2. COThank you! This is awesome- Can you clarify something I'm confused about: Does the computer I install my program on have you also have the database installed or can I bundle that with my program?
      singulars
      1. PO
      1. USstormist
    3. COIt really depends on the database used. For instance, if you are using SQL Server compact edition, you only need few dlls for engine and a database file - all of which can be XCopy deployed. For full SQL Server, you need to have the database system installed, but of course, you could bundle it within a custom installer. Not sure what are requirements for PostgreSQL and MySQL.
      singulars
      1. PO
      1. USMiroslav Popovic
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload