Databases
StackOverflow2013
Postsdbo
POORM Suggestions –With Sprocs
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POORM Suggestions –With Sprocs
    primarykey
    data
    text
    <p>Ok, I have a question that I know is very opinionated (based on all the posts I have read), but I need help. Long story short, I have been using the following model for Data access for past few years.</p> <p>Database->Sprocs->XSD(Typed dataset, drag drop sproc in.net)-> In DAL project make functions to call created methods made by XSD, load all the data then map to projects business objects.</p> <p>The pros of this:</p> <p>1) Easy drop drag to create SQL calls</p> <p>2) Sprocs are almost a most due to other constraints and easy to add</p> <p>3) Project uses own Business objects that fit the solution and not the database, I just map them in C#</p> <p>4) Code mapping, easy to refactor</p> <p>5) who doesn’t like everything to be typed and intellisensed</p> <p>Cons: 1) Slow to build</p> <p>2)Slow to pull data (Table adapter and datasets have bad performance compared to a datareader)</p> <p>3) Buggy when it comes to null vales. And boy can this krap be buggy and this wastes a lot of time.</p> <p>So that’s what I’ve been doing and not being an idiot, I realized there has to be better ways. So I have spent the last week looking at NHiberabte, LINQ to SQL, Entity Framework, or going back to doing it all with code with datareaders and untyped.</p> <p><strong>SO, the question is what is a good database (sprocs likely to Objects) mapper .</strong></p> <p>My thoughts on the 3 I looked at:</p> <p>1)Linq to SQL – Well its only SQL and Microsoft pretty much has said it’s a dead technology, so seems pointless.</p> <p>2) Entity Framework – I probably need more exposure to this one, but it seems like mapping this stuff to my own objects would put me back to where I was.</p> <p>3) Nhibernate – Looked promising, but dam I hate writing XML files and my current projects have like 30 to 50 Business objects. Also, I have to use sprocs in various areas.</p> <p>Anyone’s suggestions or a really good link to a tutorial on a good ORM would be greatly appreciated. Sorry this question is so long. Thanks, Joe</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USJojo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POORM Suggestions –With Sprocs
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POORM Suggestions –With Sprocs
      1. USCMPalmer
      1. VTFavorite
    1. This table or related slice is empty.
 

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