Linq without edmx file ~ Dotnet in simpleway

Linq without edmx file in MVC

Today we discuss about Linq without edmx file in MVC4.0

Create DataBase for this :-

create database dbMVC

use dbmvc

Create table for this :-

Create table student_info(id int primary key identity(1,1),name varchar(4),age int, check (age<100))

insert into student_info(name,age) values ('Rahul',23)

select * from student_info

First open new project in Visual Studio 2010/2012

Then select ASP.NET MVC3/4 WEB Application Visual C#

Now select Basic and click OK

Add a class with name database.cs

Code for database.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Data.Entity;

using System.ComponentModel.DataAnnotations;

using System.Web;

namespace crudoperationinmvc.Models

{

public class database:DbContext

//here we use DBContext to use DbContext(string nameOrConnectionString) Constructor

{

public database()

: base("ConStr")// ConStr is name of Connection String.

{

}

public DbSet<student> stu_info { set; get; }

}

Now add ConnectionString in Web.Config

Code for web.config

<?xml version="1.0" encoding="utf-8"?>

<!--

For more information on how to configure your ASP.NET application, please visit

http://go.microsoft.com/fwlink/?LinkId=152368

-->

</configSections>

<add name ="ConStr"

providerName="System.Data.SqlClient"

connectionString="Data Source=ramulaptop\ramukumar;

Initial Catalog=dbMVC;

Persist Security Info=True;

User Id=sa;

password=mysachi"/>

</connectionStrings>

</appSettings>

<system.web>

</authentication>

<pages>

</namespaces>

</pages>

</providers>

</profile>

</providers>

</membership>

</providers>

</roleManager>

<!--

If you are deploying to a cloud environment that has multiple web server instances,

you should change session state mode from "InProc" to "Custom". In addition,

change the connection string named "DefaultConnection" to connect to an instance

of SQL Server (including SQL Azure and SQL Compact) instead of to SQL Server Express.

-->

</providers>

</sessionState>

</system.web>

<system.webServer>

</handlers>

</system.webServer>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</assemblyBinding>

</runtime>

</entityFramework>

</configuration>

Now add Student class

code for student.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Web;

namespace crudoperationinmvc.Models

{

[Table("student_info")]

public class student

{

[Key]

[DatabaseGenerated(DatabaseGeneratedOption.Identity)]

public int id{get;set;}

public string name { get; set; }

public int? age { get; set; }

}

now add an Interface name IDataAccess.cs

Code for IDataAccess.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace crudoperationinmvc.Models

{

interface IDataAccess

{

List<student> GetStudentList();

student GetStudentDetails(int id);

void InsertStudent(student st);

void DeleteStudent(int id);

void UpdateStudent(int id, student st);

}

now add one class with name crudFunction.cs

and implement this IDataAccess Interface.

Code for crudFunction.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

namespace crudoperationinmvc.Models

{

public class CrudFunction:IDataAccess

{

database db = new database();

public List<student> GetStudentList()

{

return db.stu_info.ToList ();

}

public student GetStudentDetails(int id)

{

return db.stu_info.FirstOrDefault(m => m.id == id);

}

public void InsertStudent([Bind(Exclude="id")]student st)

{

db.stu_info.Add(st);

db.SaveChanges();

}

public void DeleteStudent(int id)

{

var v = db.stu_info.FirstOrDefault(m => m.id == id);

if (v != null)

{

db.stu_info.Remove(v);

db.SaveChanges();

}

public void UpdateStudent(int id, student st)

{

var v = db.stu_info.FirstOrDefault(m => m.id==id);

if (v != null)

{

v.name = st.name;

v.age = st.age;

db.SaveChanges();

}

now right click on controller folder in solution explorer and add controller.

with name Defalult1 and MVC controller with empty read/write actions and click add button.

code for Default1Controller.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using crudoperationinmvc.Models;

namespace crudoperationinmvc.Controllers

{

public class Default1Controller : Controller

{

IDataAccess idata;

// GET: /Default1/

public Default1Controller()

{

idata = new CrudFunction();

}

public ActionResult Index()

{

var v = idata.GetStudentList();

return View(v.ToList ());

}

// GET: /Default1/Details/5

public ActionResult Details(int id)

{

var v = idata.GetStudentDetails(id);

return View(v);

}

// GET: /Default1/Create

public ActionResult Create()

{

return View();

}

// POST: /Default1/Create

[HttpPost]

public ActionResult Create([Bind (Exclude="id")]student st)

{

try

{

// TODO: Add insert logic here

idata.InsertStudent(st);

return RedirectToAction("Index");

}

catch

{

return View();

}

// GET: /Default1/Edit/5

public ActionResult Edit(int id)

{

return View(idata.GetStudentDetails(id));

}

// POST: /Default1/Edit/5

[HttpPost]

public ActionResult Edit(int id, student st)

{

try

{

// TODO: Add update logic here

idata.UpdateStudent(id, st);

return RedirectToAction("Index");

}

catch

{

return View();

}

// GET: /Default1/Delete/5

public ActionResult Delete(int id)

{

return View(idata.GetStudentDetails(id));

}

// POST: /Default1/Delete/5

[HttpPost]

public ActionResult Delete(int id, FormCollection collection)

{

try

{

// TODO: Add delete logic here

idata.DeleteStudent(id);

return RedirectToAction("Index");

}

catch

{

return View();

}

Now right click on Index ActionResult and add strongtype view with name Index and select Model class name:- student(crudoperationinmvc.Models) and select Scaffold template:- list and click add

Code for Index.cshtml view:-

@model IEnumerable<crudoperationinmvc.Models.student>

ViewBag.Title = "Index";

}

<h2>Index</h2>

<p>

@Html.ActionLink("Create New", "Create")

</p>

<table>

<tr>

</tr>

@foreach (var item in Model)

{

<tr>

<td>@Html.DisplayFor(modelitem => item.id)</td>

<td>@Html.DisplayFor(modelitem => item.name)</td>

<td>@Html.DisplayFor(modelitem => item.age)</td>

<td>

@Html.ActionLink("Edit", "Edit", new { id = item.id }) |

@Html.ActionLink("Details", "Details", new { id = item.id }) |

@Html.ActionLink("Delete", "Delete", new { id = item.id })

</td>

</tr>

}

</table>

Now right click on Create ActionResult and add strongtype view with name Create and select Model class name:- student(crudoperationinmvc.Models) and select Scaffold template:- Create and click add

Code for Create.cshtml:-

@model crudoperationinmvc.Models.student

ViewBag.Title = "Create";

}

<h2>Create</h2>

@using (Html.BeginForm()) {

@Html.ValidationSummary(true)

<legend>student</legend>

@Html.LabelFor(model => model.name)

</div>

@Html.EditorFor(model => model.name)

@Html.ValidationMessageFor(model => model.name)

</div>

@Html.LabelFor(model => model.age)

</div>

@Html.EditorFor(model => model.age)

@Html.ValidationMessageFor(model => model.age)

</div>

<p>

</p>

</fieldset>

}

<div>

@Html.ActionLink("Back to List", "Index")

</div>

Now right click on Edit ActionResult and add strongtype view with name Edit and select Model class name:- student(crudoperationinmvc.Models) and select Scaffold template:- Edit and click add

code for Edit.cshtml

@model crudoperationinmvc.Models.student

ViewBag.Title = "Edit";

}

@using (Html.BeginForm()) {

@Html.ValidationSummary(true)

<legend>student</legend>

@Html.HiddenFor(model => model.id)

@Html.LabelFor(model => model.name)

</div>

@Html.EditorFor(model => model.name)

@Html.ValidationMessageFor(model => model.name)

</div>

@Html.LabelFor(model => model.age)

</div>

@Html.EditorFor(model => model.age)

@Html.ValidationMessageFor(model => model.age)

</div>

<p>

</p>

</fieldset>

}

<div>

@Html.ActionLink("Back to List", "Index")

</div>

Now right click on Details ActionResult and add strongtype view with name Details and select Model class name:- student(crudoperationinmvc.Models) and select Scaffold template:- Details and click add

code for Details.cshtml

@model crudoperationinmvc.Models.student

ViewBag.Title = "Details";

}

<h2>Details</h2>

<legend>student</legend>

@Html.DisplayNameFor(model => model.name)

</div>

@Html.DisplayFor(model => model.name)

</div>

@Html.DisplayNameFor(model => model.age)

</div>

@Html.DisplayFor(model => model.age)

</div>

</fieldset>

<p>

@Html.ActionLink("Edit", "Edit", new { id=Model.id }) |

@Html.ActionLink("Back to List", "Index")

</p>

Now right click on Delete ActionResult and add strongtype view with name Delete and select Model class name:- student(crudoperationinmvc.Models) and select Scaffold template:- Delete and click add

code for Delete.cshtml

@model crudoperationinmvc.Models.student

Layout = null;

}

<!DOCTYPE html>

<html>

<head>

<title>Delete</title>

</head>

<body>

<h3>Are you sure you want to delete this?</h3>

<legend>student</legend>

@Html.DisplayNameFor(model => model.name)

</div>

@Html.DisplayFor(model => model.name)

</div>

@Html.DisplayNameFor(model => model.age)

</div>

@Html.DisplayFor(model => model.age)

</div>

</fieldset>

@using (Html.BeginForm()) {

<p>

<input type="submit" value="Delete" /> |

@Html.ActionLink("Back to List", "Index")

</p>

}

</body>

</html>

Dotnet in simpleway

About Me

Thursday, 13 February 2014