using the ASP.NET MVC2 without the Entity Framework

Question

I am learning asp.net MVC, as I have been using the sqlconnection, sqlcommands etc from my initial phases, I would like to initially start learning asp.net MVC without using the entity framework.

Can you give me a link or any idea of using the models to process data without using the entity framework.

The answers provide a good starting point. But don't forget to abstract away the points of data access. That way if you decide to use EF in the future you swap your ADO.NET implementations out. This will also help with testability. — James Hulse
– James Hulse, Commented Mar 17, 2011 at 4:02

gideon · Accepted Answer · 2011-03-17 04:04:28Z

2

So without entity framework you'll be using ADO.NET (See MSDN)

Those classes you mentioned SqlConnection, SqlCommand are part of the ADO.NET framework. The two Microsoft frameworks that build on this are Entity Framework and LinqToSQL.

If you don't want to us either you have to write you own models/classes, and then methods to persist those models into your database. (This is essentially what EF does) You won't get any LINQ or designers etc.

Also, ADO.NET does have a way to create strongly typed datasets. This might help a little.

What you are doing might help you understand whats going on under the covers, but do realize frameworks like Entity-Framework save a lot of time and effort by generating models for you.

edited Mar 17, 2011 at 4:04

answered Mar 17, 2011 at 3:58

gideon

19.5k11 gold badges74 silver badges114 bronze badges

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

9 Comments

Saravanan Over a year ago

Hi giddy, thanks for your reply. Currently i am having my models with the sqlconnections and datasets etc.. I am returning the datarow objects from the model and getting them in the controller and passing them to the view and displaying data there. But what do i need is to know whether there is any way for me to pass datarow to a view like {return View(model.MovieDetails(id));}. If i send so, how can i receive the datarow in the view and display the data there.

gideon Over a year ago

ok. So depending on what version of asp.net you use, you can (1) define your model for the view as the type returned by model.MovieDetails(id) (Write @model <typename> for razor/cshtml or Inherits="ViewPage<Your type>") Then return View(modle...) should work.

gideon Over a year ago

(2) You can use ViewData or If you are on .net 4 you can use the C#4 dynamic keyword with ViewBag to pass any type from the controller to the view. See weblogs.asp.net/scottgu/archive/2007/12/06/…

gideon Over a year ago

@saravanan Also see this.weblogs.asp.net/gunnarpeipman/archive/2010/07/27/…

Saravanan Over a year ago

@giddy Thanks for the links. I am using .net framework V4.0, VS2010 and MVC 2.0. Currently the ViewData works fine. But let me explore on the other options so that i can create a strongly typed views.

|

Collectives™ on Stack Overflow

using the ASP.NET MVC2 without the Entity Framework

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related