Create Web API without Entity Framework

Question

I was wondering if is it possible to create a Web API without Entity Framework.

This should be strange but supposing to have this table

T_BOOKS:

BookId int
BookTitle nvarchar(50)

and a stored procedure that returns me something like that

select BookId, BookTitle 
from T_BOOKS

Then I add a column to both the table and the stored procedure

T_BOOKS:

BookId int
BookTitle nvarchar(50)
BookAuthor nvarchar(50)

select BookId, BookTitle, BookAuthor 
from T_BOOKS

Why should I change the controller and redeploy entire WebAPI ?

Any answer is appreciated.

Many thanks!

user3021830 · Accepted Answer · 2015-02-20 09:41:42Z

2

WebAPI and Entity Framework are two different technologies. One is a framework to provide easy to create HTTP services while other is a Framework for data access.

You, of course, can provide data to a Web API with any data provider you like. Entity Framework is a choice while, ADO.NET, NHibernate and other technologies may be other choices.

answered Feb 20, 2015 at 9:41

user3021830

2,9443 gold badges26 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Brandon Gano · Accepted Answer · 2015-02-20 09:41:42Z

2

Entity Framework is not necessary for Web API. You can retrieve and return the data using any method you prefer.

answered Feb 20, 2015 at 9:41

Brandon Gano

6,7901 gold badge29 silver badges28 bronze badges

Collectives™ on Stack Overflow

Create Web API without Entity Framework

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related