Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strike>Linq to SQL is deprecated by MS. If you want to stick with MS Frameworks take a look at Entity Framework.</strike> (See comments)</p> <p>I would advice to use NHibernate. If you use their fluent configuration or even auto configuration you can easily build a simple system. As soon as you need something more sophisticated NHibernate has the power you need.</p> <p>Of course this won't be the simplest way to do CURD, however database access is no simple topic and should need some thought.</p> <p>You can google for active record implementations for .net if you want to take the ruby on rails approach, which is quite pragmatic and elegant, too.</p> <p>Edit to provide you with a sample take a look at the NH getting started guide: <a href="http://nhforge.org/wikis/howtonh/your-first-nhibernate-based-application.aspx" rel="nofollow">http://nhforge.org/wikis/howtonh/your-first-nhibernate-based-application.aspx</a></p> <p>It's relatively easy to get going with NHibernate. As you require more sophisticated features you can drill deeper into the framework.</p> <p>Notice that the getting started guide uses XML Mapping Configuration. You can use <a href="http://fluentnhibernate.org/" rel="nofollow">http://fluentnhibernate.org/</a> to fluently configure your mappings like:</p> <pre><code>public class SomeTypeMap : ClassMap&lt;SomeType&gt; { Id(x =&gt; x.Id); Map(x =&gt; x.Property1); Map(x =&gt; x.Property2); // .... Map(x =&gt; x.PropertyN); } </code></pre> <p>The fluent interface exposes all further functions chained on the Map() method.</p> <p>Fluent NH even provides Auto Mapping: <a href="http://wiki.fluentnhibernate.org/Auto_mapping" rel="nofollow">http://wiki.fluentnhibernate.org/Auto_mapping</a></p>
    singulars
    1. This table or related slice is empty.
    1. POlinq to sql for CRUD framework
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USZebi
    1. USZebi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POlinq to sql for CRUD framework
      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. VTDownMod
    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. VTUpMod
    1. COSeem like i need to take a look at the linq to NHibernate.. it is completely new to me.
      singulars
      1. PO
      1. USVeecoTech
    2. CO@Zebi: Could you provide me a good sample code on NHibernate?
      singulars
      1. PO
      1. USVeecoTech
    3. COWe are still using NHibernate 2.x + linq2nhibernate however I think NH 3.0 already includes build in linq support.
      singulars
      1. PO
      1. USZebi
 

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