ARTICLE

Creating a Model Class to "LINQ to SQL" using ASP.NET MVC

Posted by Manish Singh Articles | ASP.NET MVC December 06, 2011
This is a simple application that show how to create model class to Link to Sql in MVC ASP.NET. In this application we first create the database after that create the schema and insert the data.
Reader Level:

Introduction: This is a simple application that show how to create model class to Link to Sql in MVC ASP.NET. In this application we first create the database after that create the schema and insert the data. After that we add the one Linq to SQL class in the model folder and drag and drop a table schema. We know that MVC is the separated word that is models,views,controllers. In model folder we have create the business logic.views is provide GUI and last controller handle the all request provide by models and views.ASP.NET MVC provide some tools that used add the data base in your application easily. This is a very simple program I hope it's very helpful  for beginners and solve the problem how to create database in a MVC application.

 Step 1: Open Visual Studio 2010.

  • Click file ->New->Projects
  • Create a MVC ASP. NET 2 Empty Web application
  • The name of the application is "manish"
start.gif

Step 2: Next step add one folder in Solution Explorer.

  • Right Click on Solution Explorer->Add->Folder
  • Name of folder "App_Data"
addfolder.gif

Step 3: In a App_Data folder,  add Sqldatabase.

  • Right Click on the App_Data Folder->Add New Item-> add "SQL database" class
  • Name of sql database is "manish"
database.gif

Step 4: After adding the SQL database, two files are created in the folder.

  • First is "manish.mdf"
  • Second is "manish_log.ldf"
jiijui.gif

Step5: Open the Server Explorer.

  • Right Click on "manish.mdf"->Add Table Schema
  • Set the fields "Name of film,Id,Name of director,Name of producer"
server.gif

addtable.gif

savetable.gif

saveteb.gif

Step6: Set the primary key

  • Right click on "ID" Fields and set Primary key.
setprim.gif

Step7: Open table

  • Insert data
tabledata.gif

Step 8:Add Linq to SQL class.

  • Right Click on models folder->add new items->add Linq to SQL class
  • After that drag&drop table shema
add-database..gif


linktosql.gif
droptable-inlinqtosql.gif

COMMENT USING