public SystemService( CodeFirstDbContext dbContext) { //_userManager = userManager; //_roleManager = roleManager; _dbContext = dbContext; }
protected void Page_Load(object sender, EventArgs e) { using (var db = new CodeFirstDbContext()) { var course = new Course { Name = "Algorihms", Description = "gadno", Materials = "za sega njama" }; //var material = "za sega njama"; //course.Materials.Add(material); db.Courses.Add(course); var student = new Student { Name = "Pesho", Number = 10000 }; student.Cources.Add(course); db.Students.Add(student); try { db.SaveChanges(); } catch (Exception exception) { Response.Write(exception.InnerException.InnerException.Message); } } }
private static void DeleteStudentById(int wantedId) { var db = new CodeFirstDbContext(); var itemToRemove = db.Students.SingleOrDefault(x => x.Id == wantedId); // returns a single item. if (itemToRemove != null) { db.Students.Remove(itemToRemove); db.SaveChanges(); } }
// GET: User public ActionResult Index() { using (CodeFirstDbContext db = new CodeFirstDbContext()) { var userList = db.User.ToList().Select(u => new UserViewModel() { Id = u.Id, Username = u.Username, Password = u.Password, Name = u.Name, }); return(View(userList)); } }
public static void Main(string[] args) { Database.SetInitializer(new MigrateDatabaseToLatestVersion <CodeFirstDbContext, Configuration>()); var db = new CodeFirstDbContext(); var newCourse = new Course() { Name = "Databases", Description = @"In this course we are learning about MSSQL, MySQL, MongoDB, ADNO.NET, DatabaseFirst & CodeFirst techniques, ENtityFramework and others." }; //// db.Courses.Add(newCourse); //// DeleteCourseById(); var newStudent = new Student() { FirstName = "John", LastName = "Snow", BirthDate = new DateTime(1980, 04, 20, 11, 59, 59), Gender = Gender.Male, StudentNumber = 123456789 }; //// db.Students.Add(newStudent); //// DeleteStudentById(2); var newHomework = new Homework() { Title = "Code First Entity Framework", Attachments = new byte[1000 * 1000 * 3], AttachmentsName = "codeFirstHomework", AttachmentsExtension = "zip", CourseId = 3, StudentId = 3 }; db.Homeworks.Add(newHomework); db.SaveChanges(); Console.WriteLine(db.Courses.Count()); Console.WriteLine(db.Students.Count()); Console.WriteLine(db.Homeworks.Count()); }
/// <summary> /// 设置数据库初始化,策略为自动迁移到最新版本 /// </summary> public static void Initialize() { CodeFirstDbContext context = new CodeFirstDbContext(); IDatabaseInitializer<CodeFirstDbContext> initializer; //if (!context.Database.Exists()) //{ // initializer = new CreateDatabaseIfNotExistsWithSeed(); //} //else //{ initializer = new MigrateDatabaseToLatestVersion<CodeFirstDbContext, MigrationsConfiguration>(); //} Database.SetInitializer(initializer); //EF预热,解决EF6第一次加载慢的问题 ObjectContext objectContext = ((IObjectContextAdapter)context).ObjectContext; StorageMappingItemCollection mappingItemCollection = (StorageMappingItemCollection)objectContext.ObjectStateManager .MetadataWorkspace.GetItemCollection(DataSpace.CSSpace); mappingItemCollection.GenerateViews(new List<EdmSchemaError>()); context.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { CodeFirstDbContext db = new CodeFirstDbContext(); //db.Kategori.Add(new Category() //{ // CategoryName = "İçecek2", // Description = "Açıklama2" //}); //db.SaveChanges(); //Product su = new Product(); //su.CategoryID = 2; //su.ProductName = "Suasdsadsadsada"; //su.ExpiredDate = DateTime.Now; //su.Cesit = "aaa"; //su.UruneOzelKolon = 5; //db.Urun.Add(su); //db.SaveChanges(); var result = db.Urun.FirstOrDefault(); var result2 = db.Kategori.ToList(); }
public CodeFirstDbService(CodeFirstDbContext context) { _context = context; }
public CodeFirstDbContext Get() { return(dataContext ?? (dataContext = new CodeFirstDbContext())); }
public SqlServerDbService(CodeFirstDbContext context) { _context = context; }