Search code examples
sql-serverdata-access-layer

What tool to use to retrieve data from database stored procedure?

I have a stored procedure which will be used to populate a report in ASP.NET. My application mainly contains SELECT queries and it has to be developed quickly and be changeable in the future.

I'd need to decide which tool to use to work with this stored procedure.

Factors:

  1. Speed of Development with above average performance
  2. Maintenance
  3. Future support and stability of the technology
  4. Performance

My options are:

  • Plain ADO.NET: which makes my development slow whereas it has to be finished in 2 days.
  • LINQ to SQL
  • Entity Framework 4.0
  • Enterprise Library Data Access
  • ...?

It's been a long time I haven't used any of these.

Please advise.

Solution

  • If you're simply calling a stored procedure and getting the results, I would stick with plain ADO.NET.

    There's no reason to go over the time limit (it really should only take an hour or so) and you won't have any ORM headaches to deal with.