Databases
StackOverflow2013
Postsdbo
POA better way to use Stored Procedures in ASP.NET?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POA better way to use Stored Procedures in ASP.NET?
    primarykey
    data
    text
    <p>I'm currently employed at a small ASP.NET/MS-SQL shop. My team has noticed that a very large amount of our development (and bugfixing) time is spent on our ADO.NET Database Access code. We're looking for a software solution that eases the process of mapping the DataTable/SQLDataReader results to proper business objects. Manually specifying column names and casting the results is becoming a nightmare (especially when schema changes are involved).</p> <p>So far, Entity Framework (and to a lesser extent, LINQ-to-SQL) has been the only piece of software we've found that automates this process fairly well. We simply add our stored procedures to the model and let them return auto-generated Complex Types. The ability to update the model from the database is also a big plus.</p> <p>Before we start migrating any of our many projects to Entity Framework, I was wondering if there are any other options that we should look at. My team has no strong preference between ORM libraries or Code Generators.</p> <p>Some of the criteria that might help:</p> <ol> <li>All data access (including CRUD) is performed through Stored Procedures on SQL Server 2008R2. <strong>Please don't answer "stop using stored procedures"</strong>. An ORM would make an incredible amount of sense in our situation, but our DBA's decision trumps the programming team's.</li> <li>Software should help with resolving SPROC parameter names and with converting the result into some strongly typed object we can work with.</li> <li>We're an academic institution with a very small budget. We've pretty much expended our budget this year (we got Resharper licenses - thankfully at a reduced price), so commercial solutions with a hefty price tag are out.</li> <li>We are not able to use GPL libraries. LGPL/BSD or anything similar are fine</li> <li>We're looking to make things easier for our developers. Moving the column/type information from C# to manually-written XML doesn't really make their jobs any easier. We're looking for something as automated as possible.</li> </ol>
    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. USJared S
    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
    1. This table or related slice is empty.
    1. CO"An ORM would make an incredible amount of sense in our situation, but our DBA's decision trumps the programming team's" - is that a Business decision, or just the DBA's say?
      singulars
      1. POA better way to use Stored Procedures in ASP.NET?
      1. USMitch Wheat
    2. COUse **Entity Framework 4** (.NET 4) - it supports stored procedures really well - for any operation! (most other ORM don't even begin to try to do so....)
      singulars
      1. POA better way to use Stored Procedures in ASP.NET?
      1. USmarc_s
    3. CO@marc_s: Which ORMs are you thinking of that don't support stored procedures? I can't think of one that matters off the top of my head.
      singulars
      1. POA better way to use Stored Procedures in ASP.NET?
      1. USMichael Maddox
 

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