Today's Question:  What weekend projects have you created?        GIVE A SHOUT

Technical Article => Web =>  ASP.NET

Creating Working application in 15 minutes in ASP.NET MVC with Entity Framework and Scaffolded Items

  edwardbrooks      2016-12-21 00:10:00      1,790    0

You can create a working application in MVC at your place. development services providers bring this tutorial to make you learn about the use of Entity framework and Scaffolded items for mvc application development. Read this and share your experience at the end.

In this post we going to use Microsoft technology to create a fully working web application which going to contain a fully featured CRUD capabilities.

So first of all let’s create, a new table which going to be the data source that we going to manipulate through our application, I’m going to use SQL server for that purpose. I’m going to call this table Products and going to create 4 simple rows there:

Let’s now populate our recently created table with some simple data, just few rows in order to be able to see the data in our application which we going to create next:

Let’s now open the visual studio to create our application. For that purpose, I’m going to use visual studio 2015 (you can use all versions, since all of them offers you the capabilities that we going to need). 

First I’m going to create a new project, in the project creation wizard, I’m going to choose ASP.NET Web Application and click OK.

In the next screen I’m going to choose MVC template (this template generates a sample application with bootstrap framework styling). Please pay attention, I’m going to change the authentication type to no authentication, you could choose other type, and in that case visual studio going to auto generate authentication capabilities for you.

This should be the structure of the project that visual studio going to generate for us.

Now let’s create data layer, which going to be managed by the Entity Framework.

For that right click over the models folder and choose add new item. In the wizard that appears you should choose ADO.NET Entity Data Model and give it a meaningful name.

In the next step choose EF Designer from database:

Then please make sure that you already have connection string inserted into your projects webconfig file. In my case it’s called LocalDBConnection that pointing to the table that we’ve created in the beginning:

Next choose the connection string in the wizard and on the next screen choose the table (or tables) that you want to be managed by entity framework.

After you click finish, the following structure should be generated in your models folder. That all that you need to manage your tables in database from your application. Next let’s take a look at the front end.

Go to the next path Controllers -> Add -> New Scaffolded Item. Here you going to choose MVC 5 Controller with views, using Entity Framework, which is supposed to generate CRUD capabilities for your recently generated models by Entity Framework.

In the Model Class select the Name of the table that you want to scaffold, and in the data context class select the name of the connection string which was generated by Entity Framework (while you’ve accomplished generating your models through entity framework a new connection was added to your connection strings collection in the web config file, all that is done automatically).

Pay attention, if you have any error during the scaffolding it’s because you didn’t had rebuilt your project. So you should do the following: clean the solution, close visual studio and then open it again, and then build your project (project, not solution). Then try to repeat the scaffolding steps again.

The following structure should be generated after executing the previous step. These are views, models and controllers responsible to show, edit, delete and create the data in the table that we’ve created in the beginning:

Also we can go to the _layout view and add new item to the nav bar in order to have a link for our recently created views.

Let’s launch the application and see the result:

Here you have the fully working application. You can try to edit delete and create a new product and you will see that everything works correctly and updates database.

So this is the way that the modern technology helps to speed up your development.

And this scaffolded application could be a good starting point for the new developments.

Experts offering development services have explained the way to create working application in no time in MVC. You can use the entity framework and scaffolded items as explained in this post. Don't forget to write your experience here.




Share on Facebook  Share on Twitter  Share on Google+  Share on Weibo  Share on Reddit  Share on Digg  Share on Tumblr    Delicious



No comment for this article.


A programmer in a room full of PMs

By sonic0002