C#_MVC_Repository_CRUD_Model

using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;namespace iFlytekDemo.Models
{///

Employees { get; set; }}
}

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Linq.Expressions;
using System.Web;namespace iFlytekDemo.Models
{ public class CityRepository : ICityRepository{iFlytekDemoContext context &＃61; new iFlytekDemoContext();public IQueryable All{get { return context.Cities; }}public IQueryable AllIncluding(params Expressionobject>>[] includeProperties){IQueryable query &＃61; context.Cities;foreach (var includeProperty in includeProperties) {query &＃61; query.Include(includeProperty);}return query;}public City Find(int id){return context.Cities.Find(id);}public void InsertOrUpdate(City city){if (city.CityID &＃61;&＃61; default(int)) {// New entitycontext.Cities.Add(city);} else {// Existing entitycontext.Entry(city).State &＃61; EntityState.Modified;}}public void Delete(int id){var city &＃61; context.Cities.Find(id);context.Cities.Remove(city);}public void Save(){context.SaveChanges();}public void Dispose() {context.Dispose();}}public interface ICityRepository : IDisposable{IQueryable All { get; }IQueryable AllIncluding(params Expressionobject>>[] includeProperties);City Find(int id);void InsertOrUpdate(City city);void Delete(int id);void Save();}
}

using System.ComponentModel.DataAnnotations;namespace iFlytekDemo.Models
{///

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Linq.Expressions;
using System.Web;namespace iFlytekDemo.Models
{ public class EmployeeRepository : IEmployeeRepository{iFlytekDemoContext context &＃61; new iFlytekDemoContext();public IQueryable All{get { return context.Employees; }}public IQueryable AllIncluding(params Expressionobject>>[] includeProperties){IQueryable query &＃61; context.Employees;foreach (var includeProperty in includeProperties) {query &＃61; query.Include(includeProperty);}return query;}public Employee Find(int id){return context.Employees.Find(id);}public void InsertOrUpdate(Employee employee){if (employee.EmployeeID &＃61;&＃61; default(int)) {// New entitycontext.Employees.Add(employee);} else {// Existing entitycontext.Entry(employee).State &＃61; EntityState.Modified;}}public void Delete(int id){var employee &＃61; context.Employees.Find(id);context.Employees.Remove(employee);}public void Save(){context.SaveChanges();}public void Dispose() {context.Dispose();}}public interface IEmployeeRepository : IDisposable{IQueryable All { get; }IQueryable AllIncluding(params Expressionobject>>[] includeProperties);Employee Find(int id);void InsertOrUpdate(Employee employee);void Delete(int id);void Save();}
}

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Web;namespace iFlytekDemo.Models
{public class iFlytekDemoContext : DbContext{// You can add custom code to this file. Changes will not be overwritten.// // If you want Entity Framework to drop and regenerate your database// automatically whenever you change your model schema, add the following// code to the Application_Start method in your Global.asax file.// Note: this will destroy and re-create your database with every model change.// // System.Data.Entity.Database.SetInitializer(new System.Data.Entity.DropCreateDatabaseIfModelChanges());public DbSet Cities { get; set; }public DbSet Employees { get; set; }}
}