protected virtual void CreateOrMigrate(AbpTenantBase tenant) { var args = new DbPerTenantConnectionStringResolveArgs( tenant == null ? (int?)null : (int?)tenant.Id, tenant == null ? MultiTenancySides.Host : MultiTenancySides.Tenant ); args["DbContextType"] = typeof(TDbContext); args["DbContextConcreteType"] = typeof(TDbContext); var nameOrConnectionString = ConnectionStringHelper.GetConnectionString(_connectionStringResolver.GetNameOrConnectionString(args)); using (var uow = _unitOfWorkManager.Begin(TransactionScopeOption.Suppress)) { using (var dbContext = _iocResolver.ResolveAsDisposable <TDbContext>(new { nameOrConnectionString = nameOrConnectionString })) { var dbInitializer = new MigrateDatabaseToLatestVersion <TDbContext, TConfiguration>( true, new TConfiguration { Tenant = tenant }); dbInitializer.InitializeDatabase(dbContext.Object); _unitOfWorkManager.Current.SaveChanges(); uow.Complete(); } } }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); WebApiConfig.Register(GlobalConfiguration.Configuration); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); AuthConfig.RegisterAuth(); var context = new DREAMContext(); var initializeDomain = new CreateDatabaseIfNotExists<DREAMContext>(); var initializeMigrations = new MigrateDatabaseToLatestVersion<DREAMContext, Configuration>(); //initializeDomain.InitializeDatabase(context); //initializeMigrations.InitializeDatabase(context); //using (FSDirectory d = FSDirectory.Open(new DirectoryInfo(SearchIndex.DirPath))) //{ // SearchAutoComplete sac = new SearchAutoComplete(AppDomain.CurrentDomain.BaseDirectory + "/App_Data/SearchAutocompleteIndex"); // sac.BuildAutoCompleteIndex(d, "Keywords"); //} Database.SetInitializer(new MigrateDatabaseToLatestVersion<DREAMContext, Configuration>()); #if DEBUG && FALSE Database.SetInitializer(new DREAM.Models.DREAMContextInitializer()); #endif }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddSingleton <IHttpContextAccessor, HttpContextAccessor>(); services.AddReact(); services.AddMvc(); services.AddOptions(); services.AddAuthentication(options => { options.SignInScheme = CookieAuthenticationDefaults.AuthenticationScheme; }); #if DEBUG var connectionString = Configuration.GetValue <string>("SqlConfig_Preprod:ConnectionString"); #else var connectionString = Configuration.GetValue <string>("SqlConfig:ConnectionString"); #endif var initializer = new MigrateDatabaseToLatestVersion <CodeGolfDbContext, Sql.Migrations.Configuration>(true); Database.SetInitializer(initializer); services.AddTransient <IRepository>(x => new Repository(connectionString)); ConfigureAzureFunctionService(services); services.AddTransient <ProblemValidatorService>(); services.AddTransient <LanguageFactory>(); }
public TwitterContext() : base("TwitterContext", throwIfV1Schema: false) { var migrationStrategy = new MigrateDatabaseToLatestVersion <TwitterContext, Configuration>(); Database.SetInitializer(migrationStrategy); }
public StudentContext() : base("name=StudentContext") { var migrationStrategy = new MigrateDatabaseToLatestVersion <StudentContext, Configuration>(); Database.SetInitializer(migrationStrategy); }
public SQLServerDBContext() : base("name=connectionStringPMT") { var initializer = new MigrateDatabaseToLatestVersion <SQLServerDBContext, Migrations.Configuration>(); Database.SetInitializer(initializer); this.Configuration.LazyLoadingEnabled = false; }
public BookShopEntities() : base("BookShopEntities") { var migrateStrategy = new MigrateDatabaseToLatestVersion <BookShopEntities, Configuration>(); Database.SetInitializer(migrateStrategy); }
public ATMEntities() : base("name=ATMEntities") { var migrationStrategy = new MigrateDatabaseToLatestVersion <ATMEntities, Configuration>(); Database.SetInitializer(migrationStrategy); }
/// <summary> /// 初始化数据库 /// </summary> /// <param name="dbContext"></param> public static void InitializeDatabase(EfDbContext dbContext) { if (!Core.AppContext.Settings.IsDynamicCompany) { return; } if (string.IsNullOrEmpty(Core.AppContext.CurrentSession.CompanyCode)) { Database.SetInitializer <EfDbContext>(null); return; } lock (_lockObj) { if (_InitializedDbList.Contains(Core.AppContext.CurrentSession.CompanyCode)) { return; } _InitializedDbList.Add(Core.AppContext.CurrentSession.CompanyCode); } IDatabaseInitializer <EfDbContext> initializer; if (!dbContext.Database.Exists()) { initializer = new CreateDbIfNotExists <EfDbContext>(); } else { initializer = new MigrateDatabaseToLatestVersion <EfDbContext, MigrationsConfiguration>(); } Database.SetInitializer(initializer); }
public SoftwareContableDbContext() : base("name=SoftwareContable") { var migrationStrategy = new MigrateDatabaseToLatestVersion<SoftwareContableDbContext, Configuration>("SoftwareContable"); Database.SetInitializer(migrationStrategy); }
public ApplicationDbContext() : base("DefaultConnection", throwIfV1Schema: false) { var migration = new MigrateDatabaseToLatestVersion <ApplicationDbContext, Configuration>(); Database.SetInitializer(migration); }
/// <summary> /// 设置数据库初始化,策略为自动迁移到最新版本 /// </summary> public static void Initialize() { if (Core.AppContext.Settings.IsDynamicCompany) { return; } var context = new EfDbContext(); context.Database.CommandTimeout = 180; IDatabaseInitializer <EfDbContext> initializer; if (!context.Database.Exists()) { initializer = new CreateDbIfNotExists <EfDbContext>(); } else { initializer = new MigrateDatabaseToLatestVersion <EfDbContext, MigrationsConfiguration>(); } Database.SetInitializer(initializer); //EF预热,解决EF6第一次加载慢的问题 ObjectContext objectContext = ((IObjectContextAdapter)context).ObjectContext; var mappingItemCollection = (StorageMappingItemCollection)objectContext.ObjectStateManager .MetadataWorkspace.GetItemCollection(DataSpace.CSSpace); mappingItemCollection.GenerateViews(new List <EdmSchemaError>()); context.Dispose(); }
private static void MigrateUsingInitializer() { var initializer = new MigrateDatabaseToLatestVersion <GlobalDataContext, Configuration>("MigrationDemo"); Database.SetInitializer <GlobalDataContext>(initializer); PrintSeededData(); }
/// <summary> /// 数据库初始化,自动迁移到最新版本 /// </summary> public static void Initialize <TContext, TMigrationsConfiguration>(Action <TContext> callback = null) where TContext : DbContext, new() where TMigrationsConfiguration : DbMigrationsConfiguration <TContext>, new() { IDatabaseInitializer <TContext> initializer; var context = new TContext(); if (!context.Database.Exists()) { initializer = new CreateDatabaseIfNotExists <TContext>(); } else { initializer = new MigrateDatabaseToLatestVersion <TContext, TMigrationsConfiguration>(); } Database.SetInitializer(initializer); // 预先生成EF的映射视图 using (context) { PreMapping(context); if (callback != null) { callback(context); } } }
static void Main() { var context = new PhoneBookContext(); var migrationStrategy = new MigrateDatabaseToLatestVersion<PhoneBookContext, Configuration>(); Database.SetInitializer(migrationStrategy); var contacts = context.Contacts .Select(c => new { c.Name, Phones = c.Phones.Select(p => p.PhoneNumber), Emails = c.Emails.Select(e => e.EmailAddress) }).ToList(); foreach (var contact in contacts) { Console.WriteLine(contact.Name); //foreach (var phone in contact.Phones) //{ // Console.WriteLine(phone); //} //foreach (var e in contact.Emails) //{ // Console.WriteLine(e); //} Console.WriteLine("Phones: {0}", string.Join(", ", contact.Phones)); Console.WriteLine("Emails: {0}", string.Join(", ", contact.Emails)); Console.WriteLine(); } }
public static void Initialize() { var initializeMigrations = new MigrateDatabaseToLatestVersion <MyDataContext, Migrations.Configuration>(); initializeMigrations.InitializeDatabase(new MyDataContext()); }
public LibraryDbContext() : base("LibraryDbContext") { var migration = new MigrateDatabaseToLatestVersion <LibraryDbContext, Configuration>(); Database.SetInitializer(migration); }
public static ApplicationDbContext Create() { IDatabaseInitializer <ApplicationDbContext> strategy; switch (ConfigurationManager.AppSettings["Database_Initialize_Strategy"]) { case "CreateDatabaseIfNotExists": strategy = new CreateDatabaseIfNotExists <ApplicationDbContext>(); break; case "DropCreateDatabaseAlways": strategy = new DropCreateDatabaseAlways <ApplicationDbContext>(); break; case "DropCreateDatabaseIfModelChanges": strategy = new DropCreateDatabaseIfModelChanges <ApplicationDbContext>(); break; case "MigrateDatabaseToLatestVersion": strategy = new MigrateDatabaseToLatestVersion <ApplicationDbContext, Configuration>(); break; default: strategy = new NullDatabaseInitializer <ApplicationDbContext>(); break; } Database.SetInitializer(strategy); return(new ApplicationDbContext()); }
// Your context has been configured to use a 'MovieEntities' connection string from your application's // configuration file (App.config or Web.config). By default, this connection string targets the // '_05.CodeFirstMovies.MovieEntities' database on your LocalDb instance. // // If you wish to target a different database and/or database provider, modify the 'MovieEntities' // connection string in the application configuration file. public MovieEntities() : base("MovieEntities") { var migration = new MigrateDatabaseToLatestVersion <MovieEntities, Configuration>(); Database.SetInitializer(migration); }
static void Main() { var migrationStrategy = new MigrateDatabaseToLatestVersion <BookShopContext, Configuration>(); Database.SetInitializer(migrationStrategy); var context = new BookShopContext(); var books = context.Books .Take(3) .ToList(); books[0].RelatedBooks.Add(books[1]); books[1].RelatedBooks.Add(books[0]); books[0].RelatedBooks.Add(books[2]); books[2].RelatedBooks.Add(books[0]); context.SaveChanges(); var booksFromQuery = context.Books.Take(3).ToList(); foreach (var book in booksFromQuery) { Console.WriteLine("--{0}", book.Title); foreach (var relatedBook in book.RelatedBooks) { Console.WriteLine(relatedBook.Title); } } }
public void MigrateDatabaseToLatestVersion_throws_when_given_invalid_connection_name() { var init = new MigrateDatabaseToLatestVersion <EmptyContext, TestMigrationsConfiguration>("YouWontFindMe"); Assert.Equal( Strings.DbContext_ConnectionStringNotFound("YouWontFindMe"), Assert.Throws <InvalidOperationException>(() => init.InitializeDatabase(new EmptyContext())).Message); }
public EscortServiceHouseEntities() : base("EscortServiceHouseEntities") { var strategy = new MigrateDatabaseToLatestVersion <EscortServiceHouseEntities, Configuration>(); Database.SetInitializer(strategy); }
public BookShopContext() : base("BookShopContext") { IDatabaseInitializer <BookShopContext> migrationStrategy = new MigrateDatabaseToLatestVersion <BookShopContext, Configuration>(); Database.SetInitializer(migrationStrategy); }
public MoviesEntities() : base("name=MoviesEntities") { var dropCreate = new DropCreateDatabaseAlways<MoviesEntities>(); var migrateToLatest = new MigrateDatabaseToLatestVersion<MoviesEntities, Configuration>(); Database.SetInitializer(migrateToLatest); }
public StudentSystemContext() : base("StudentSystemContext") { IDatabaseInitializer <StudentSystemContext> migrationStrategy = new MigrateDatabaseToLatestVersion <StudentSystemContext, Configuration>(); Database.SetInitializer(migrationStrategy); }
public SupermarketChainOracleContext() : base("OracleDbContext") { var migration = new MigrateDatabaseToLatestVersion <SupermarketChainOracleContext, OracleConfiguration>(); //var migration = new DropCreateDatabaseAlways<SupermarketChainOracleContext>(); Database.SetInitializer(migration); }
public SqlServerDbContextInitializer() { DatabaseInitializer = new SqlServerCreateDatabaseIfNotExistsWithSeed(); if (EnabledAutoMigrate) { DatabaseInitializer = new MigrateDatabaseToLatestVersion <UbpDbContext, SqlServerMigrationsConfiguration>(); } }
/// <summary> /// 初始化一个<see cref="DbContextInitializerBase"/>类型的新实例 /// </summary> protected DbContextInitializerBase() { DatabaseInitializer = new CreateDatabaseIfNotExists <TDbContext>(); if (EnabledAutoMigrate) { DatabaseInitializer = new MigrateDatabaseToLatestVersion <TDbContext, AutoMigrationsConfiguration <TDbContext> >(); } }
public OracleDbContext() : base("name=OracleDbContext") { var migrationStrategy = new MigrateDatabaseToLatestVersion<OracleDbContext, Configuration>(); //var migrationStrategy = new DropCreateDatabaseAlways<OracleDbContext>(); Database.SetInitializer(migrationStrategy); Database.Initialize(false); }
public static void Main() { var migrationStrategy = new MigrateDatabaseToLatestVersion <BookShopContext, Configuration>(); Database.SetInitializer(migrationStrategy); var context = new BookShopContext(); var bookCount = context.Books.Count(); }
private void initDatabase() { using (DatabaseContext database = new DatabaseContext()) { MigrateDatabaseToLatestVersion <DatabaseContext, Configuration> migrate = new MigrateDatabaseToLatestVersion <DatabaseContext, Configuration>(); Database.SetInitializer <DatabaseContext>(migrate); migrate.InitializeDatabase(database); } }
static void Main() { var migrationStrategy = new MigrateDatabaseToLatestVersion<BookShopContext, Configuration>(); Database.SetInitializer(migrationStrategy); var context = new BookShopContext(); var bookCount = context.Books.Count(); //- to insialize the DB }
private static void Initialize() { var initializer = new MigrateDatabaseToLatestVersion<Context, DbConfig>(); Database.SetInitializer(initializer); using (var context = new Context()) { context.Database.Initialize(force: true); context.SaveChanges(); } }
public void InitializeDatabase(TContext context) { var step1 = new DropCreateDatabaseAlways <TContext>(); step1.InitializeDatabase(context); var step2 = new MigrateDatabaseToLatestVersion <TContext, TMigrationsConfiguration>(); step2.InitializeDatabase(context); }
public static void Main(string[] args) { var strategy = new MigrateDatabaseToLatestVersion <BookShopContext, Configuration>(); Database.SetInitializer(strategy); var context = new BookShopContext(); Console.WriteLine(context.Authors.Count()); }
static void Main(string[] args) { var initializer = new MigrateDatabaseToLatestVersion <ForumContext, Configuration>(); Database.SetInitializer(initializer); var context = new ForumContext(); context.Database.Initialize(true); }
protected override void Init() { Database.SetInitializer<BralekDbContext>(null); // forcing the application of the migrations so the users table is modified before // the code below tries to create it. using (var context = new BralekDbContext("DefaultConnection")) { var migrations = new MigrateDatabaseToLatestVersion<BralekDbContext, Configuration>(); migrations.InitializeDatabase(context); } }
/// <summary> /// Runs the migration /// </summary> /// <remarks> /// We can do this, or just run Update-Database in the IDE command line /// </remarks> /// <param name="args">Console arguments</param> static void Main(string[] args) { SetConnectionString(args); var databaseInitializer = new MigrateDatabaseToLatestVersion<EntityMigrateDatabaseContext, EntityMigrationConfiguration>(); var databaseContext = new EntityMigrateDatabaseContext(); databaseInitializer.InitializeDatabase(databaseContext); // Run any post migration work here (ex: installing SSIS packages, building matching database, etc) // --> databaseContext.Database.ExecuteSqlCommand() }
public static void AssemblyInit(TestContext context) { const string connectionStringName = "ProductContext"; CreateTestDatabase.TestDatabase.Create(connectionStringName); //optional - run Entity Framework migrations var migrate = new MigrateDatabaseToLatestVersion<ProductContext, Configuration>(connectionStringName); using (var dbContext = new ProductContext()) { migrate.InitializeDatabase(dbContext); } }
protected void Application_Start() { var migration = new MigrateDatabaseToLatestVersion<NewsSystemContext, Configuration>(); Database.SetInitializer(migration); GlobalConfiguration.Configuration.Formatters.JsonFormatter.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore; AreaRegistration.RegisterAllAreas(); WebApiConfig.Register(GlobalConfiguration.Configuration); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); this.ConfigureDependencyResolver(GlobalConfiguration.Configuration); }
protected void Application_Start() { ApplicationDBContext db = new ApplicationDBContext(); //Init the datbase, and apply any pending updates/changes //NOTE: Entity Framework MUST update the database BEFORE the following WebSecurity block. // If Entity Framework does not find that database thet why it left it, then it gets testy try { var updateDBInit = new MigrateDatabaseToLatestVersion<ApplicationDBContext, Configuration>(); updateDBInit.InitializeDatabase(db); } catch (Exception e) { } //Init Security //NOTE: Entity Framework MUST update the database BEFORE this WebSecurity block. // If Entity Framework does not find that database thet why it left it, then it gets testy try { if (!WebSecurity.Initialized) { WebSecurity.InitializeDatabaseConnection("ApplicationDBContext", "UserProfile", "UserId", "UserName", autoCreateTables: true); } } catch (Exception e) { } AreaRegistration.RegisterAllAreas(); WebApiConfig.Register(GlobalConfiguration.Configuration); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); AuthConfig.RegisterAuth(); //Init IoC(unity) Bootstrapper.Initialise(); //Remove all but the Razor View Engine for some extra Perf ViewEngines.Engines.Clear(); ViewEngines.Engines.Add(new RazorViewEngine()); //Load Tax Periods into globaly available static structure TaxPeriods.Load(); }
static void Main() { var context=new BookShopContext(); var migrationStrategy = new MigrateDatabaseToLatestVersion<BookShopContext,Configuration>(); Database.SetInitializer(migrationStrategy); context.Database.Initialize(true); // BooksAfter2000(context); // AuthorsWithBookBefore1990(context); // BookFromSpecificAuthor(context,"George Powell"); // TestBookRealtions(context); }
public static void Main() { var migrationStrategy = new MigrateDatabaseToLatestVersion<StudentSystemContex, Configuration>(); Database.SetInitializer(migrationStrategy); var contex = new StudentSystemContex(); //ListAllStudents(contex); //ListAllCourses(contex); //ListCoursesByCount(contex); //ListAllCoursesFilteredByDate(contex); CheckStudetsAllCoursesPrice(contex); }
public static void InitConfiguration() { lock (syncObj) { using (var temp = new DataContext()) { if (temp.Database.Exists()) return; var migrationInitializer = new MigrateDatabaseToLatestVersion<DataContext, Migrations.Configuration>(); Database.SetInitializer(migrationInitializer); temp.Database.Initialize(true); } DB.OpenSession(); } }
public DefaultDbConfiguration() { IDatabaseInitializer<DefaultDbContext> databaseInitializer; if (GlobalConfig.AutomaticMigrationsEnabled) { databaseInitializer = new MigrateDatabaseToLatestVersion<DefaultDbContext, Configuration>(); SetContextFactory(typeof(DefaultDbContext), () => { var work = new HttpContextWrapper(HttpContext.Current).Request.RequestContext.GetWorkContext(); return work.Resolve<EntityFrameworkDbContextFactory>().Create(); }); } else databaseInitializer = new NullDatabaseInitializer<DefaultDbContext>(); SetDatabaseInitializer(databaseInitializer); }
//public static readonly ICollection<Assembly> MapperAssemblies = new List<Assembly>(); /// <summary> /// 设置数据库初始化,策略为自动迁移到最新版本 /// </summary> public static void Initialize() { var context = new ChiakiYuDbContext(); IDatabaseInitializer<ChiakiYuDbContext> initializer; if (!context.Database.Exists()) { initializer = new CreateDatabaseIfNotExistsWithSeed(); } else { initializer = new MigrateDatabaseToLatestVersion<ChiakiYuDbContext, Configuration>(); } Database.SetInitializer(initializer); //EF预热,解决EF6第一次加载慢的问题 var objectContext = ((IObjectContextAdapter) context).ObjectContext; var mappingItemCollection = (StorageMappingItemCollection) objectContext.ObjectStateManager .MetadataWorkspace.GetItemCollection(DataSpace.CSSpace); mappingItemCollection.GenerateViews(new List<EdmSchemaError>()); context.Dispose(); }
/// <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(); }
public static bool InitializeDatabase() { lock (syncObj) { using (var temp = new Context()) { if (temp.Database.Exists()) return true; var initializer = new MigrateDatabaseToLatestVersion<Context, ContactManager.Data.Migrations.Configuration>(); Database.SetInitializer(initializer); try { temp.Database.Initialize(true); return true; } catch (Exception ex) { //Handle Error in some way return false; } } } }
private static void MigrateUsingInitializer() { var initializer = new MigrateDatabaseToLatestVersion<GlobalDataContext, Configuration>("MigrationDemo"); Database.SetInitializer<GlobalDataContext>(initializer); PrintSeededData(); }
public EmployeeDbContext() : base("EmployeeDbContext") { var migrationStrategy = new MigrateDatabaseToLatestVersion<EmployeeDbContext, Configuration>(); Database.SetInitializer(migrationStrategy); }
public MoviesEntities() : base("MoviesEntities") { var migrationStrategy = new MigrateDatabaseToLatestVersion<MoviesEntities, Configuration>(); Database.SetInitializer(migrationStrategy); }
public SocialExperimentDbContext() { var databaseInitializer = new MigrateDatabaseToLatestVersion<SocialExperimentDbContext, SocialExperimentDbConfiguration>(); Database.SetInitializer(databaseInitializer); }
public static void Main() { var context = new BookShopContext(); var migrationStrategy = new MigrateDatabaseToLatestVersion<BookShopContext, Configuration>(); Database.SetInitializer(migrationStrategy); Console.Write("Do you want output for step 6 y/n: "); string wannaSix = Console.ReadLine(); if (wannaSix == "y") { Console.Write("Please choise part from 1 to 5: "); string input = Console.ReadLine(); switch (input) { case "1": var bookTitles = context.Books .Where(b => b.ReleaseDate.Year > 2000) .Select(b => new { b.Title }); foreach (var bookTitle in bookTitles) { Console.WriteLine(bookTitle.Title); } break; case "2": var authorsByBook = context.Authors .Where(a => a.Books .Any(b => b.ReleaseDate.Year < 1990)) .Select(a => new { FirstName = a.FirstName, LastName = a.LastName }); foreach (var author in authorsByBook) { Console.WriteLine("{0} {1}", author.FirstName, author.LastName); } break; case "3": var authors = context.Authors .OrderByDescending(a => a.Books.Count) .Select(a => new { FirstName = a.FirstName, LastName = a.LastName, BookCount = a.Books.Count }); foreach (var author in authors) { Console.WriteLine("{0} {1} - {2}", author.FirstName, author.LastName, author.BookCount); } break; case "4": var georgesBooks = context.Books .Where(b => b.Author.FirstName == "George" && b.Author.LastName == "Powell") .OrderByDescending(b => b.ReleaseDate) .ThenBy(b => b.Title) .Select(b => new { Title = b.Title, ReleaseDate = b.ReleaseDate, Copies = b.Copies }); foreach (var georgesBook in georgesBooks) { Console.WriteLine("{0} - {1} - {2}", georgesBook.Title, georgesBook.ReleaseDate, georgesBook.Copies); } break; case "5": var booksByCategories = context.Categories .OrderBy(c => c.Books.Count) .Select(c => new { Books = c.Books .OrderByDescending(b => b.ReleaseDate) .ThenBy(b => b.Title) .Take(3) .Select(b => new { BookTitle = b.Title, ReleaseDate = b.ReleaseDate }), CategoryName = c.Name, BookCount = c.Books.Count }); foreach (var booksByCategory in booksByCategories) { Console.WriteLine("--{0}: {1} books", booksByCategory.CategoryName, booksByCategory.BookCount); foreach (var book in booksByCategory.Books) { Console.WriteLine("{0} ({1})", book.BookTitle, book.ReleaseDate.Year); } } break; default: Console.WriteLine("Incorect choise."); break; } } else { var books = context.Books .Take(3) .ToList(); if (books.Count == 0) { books[0].RelatedBooks.Add(books[1]); books[1].RelatedBooks.Add(books[0]); books[0].RelatedBooks.Add(books[2]); books[2].RelatedBooks.Add(books[0]); context.SaveChanges(); } var booksFromQuery = context.Books .Take(3) .Select(b => new { Title = b.Title, RelatedBooks = b.RelatedBooks.Select(rb => new { rb.Title }) }); foreach (var book in booksFromQuery) { Console.WriteLine("--{0}", book.Title); foreach (var relatedBook in book.RelatedBooks) { Console.WriteLine(relatedBook.Title); } } } }
public PhonebookEntities() : base("name=PhonebookEntities") { var migrationStrategy = new MigrateDatabaseToLatestVersion<PhonebookEntities, Configuration>(); Database.SetInitializer(migrationStrategy); }
public Storage() { MigrateDatabaseToLatestVersion<StorageContext, Configuration> di = new MigrateDatabaseToLatestVersion<StorageContext, Configuration>(); Database.SetInitializer(di); }
public UtrepauContext() : base("UtrepauContext") { var migrations = new MigrateDatabaseToLatestVersion<UtrepauContext, Configuration>(); Database.SetInitializer(migrations); }
/// <summary> /// 设置初始化策略 /// </summary> public virtual void SetDatabaseInitializer() { var initializer = new MigrateDatabaseToLatestVersion<FzrainContext, Configuration>(); // var initializer = new DropCreateDatabaseIfModelChanges<FzrainContext>(); Database.SetInitializer(initializer); }
public StudentContext() : base("name=StudentContext") { var migrationStrategy = new MigrateDatabaseToLatestVersion<StudentContext, Configuration>(); Database.SetInitializer(migrationStrategy); }
public void MigrateDatabaseToLatestVersion() { var initializer = new MigrateDatabaseToLatestVersion<MiamDbContext,Configuration>(); Database.SetInitializer(initializer); }
static void Main(string[] args) { try { var migrate = new MigrateDatabaseToLatestVersion<DataContext, Configuration>(); Database.SetInitializer(migrate); using (var db = new DataContext()) { Console.WriteLine("数据初始化完成:部门信息{0}条,角色信息{1}条,人员信息{2}条", db.Departments.Count(), db.Roles.Count(), db.Members.Count()); } } catch (Exception e) { Console.WriteLine(new ExceptionMessage(e)); } Reinput: try { Console.WriteLine("请输入:功能1-n,退出0"); int input; if (!int.TryParse(Console.ReadLine(), out input)) { goto Reinput; } switch (input) { case 0: break; case 1: Method01(); goto Reinput; case 2: Method02(); goto Reinput; case 3: Method03(); goto Reinput; case 4: Method04(); goto Reinput; case 5: Method05(); goto Reinput; case 6: Method06(); goto Reinput; case 7: Method07(); goto Reinput; case 8: Method08(); goto Reinput; case 9: Method09(); goto Reinput; default: Console.WriteLine("编号{0}的功能不存在。\r\n", input); goto Reinput; } } catch (Exception e) { Console.WriteLine(new ExceptionMessage(e)); goto Reinput; } }