Asp.net Web API With No Entity Framework

Question

We want to start using Asp.net web api for our future enterprise services however we do not want to use EF for data access.

Are there any samples out there for Asp.net Web APi working with regular ado.net classes instead of EF?

Thanks.

Answer 1

Are you looking for code samples for how to use e.g., SqlConnection, SqlCommand, SqlDataReader?

You would use the classes in System.Data.SqlClient if you are trying to talk to SQL Server, System.Data.OracleClient if you're trying to talk to Oracle, or System.Data.Odbc if you're trying to talk to MySQL.

Here are some code samples for how to call a stored procedure from ADO.NET. Good luck!