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;
}
