static void Main() { var server = ConfigurationManager.AppSettings["Database"]; using (var db = KatsContext.Create(server: server, forceDatabaseInitialize: true)) { } Console.WriteLine("아무키나 누르세요"); Console.ReadLine(); }
/// <summary> /// 새로운 CRContext Instance를 생성 합니다. /// </summary> /// <param name="autoDetectChangesEnabled"><seealso cref="System.Data.Entity.Infrastructure.DbChangeTracker.DetectChanges" /> 메서드가 <see cref="System.Data.Entity.DbContext" /> /// 및 관련 클래스의 메서드에 의해 자동으로 호출되는지 여부를 나타내는 값을 가져오거나 설정합니다. /// <remarks>데이터 추적이 필요하지 않은 Read 작업 등에서는 false로 하면 성능이 향상 됩니다.</remarks></param> /// <param name="proxyCreationEnabled">Proxy creation enabled.(virtual 선언한 멤버가 나오게 하려면 Proxy와 Lazy load을 true로 해야 한다.</param> /// <param name="lazyLoadingEnabled">The lazy loading enabled.</param> /// <param name="validateOnSaveEnabled">Validate on save enabled</param> /// <param name="server">The server.</param> /// <param name="port">The port.</param> /// <returns>CRContext.</returns> public static KatsContext Create( bool autoDetectChangesEnabled = true, bool proxyCreationEnabled = false, bool lazyLoadingEnabled = false, bool validateOnSaveEnabled = false, string server = "localhost", uint port = Constants.DB_PORT, bool forceDatabaseInitialize = false) { var context = new KatsContext(Constants.DB_NAME, Constants.DB_USER_ID, Constants.DB_USER_PASSWORD, server, port, forceDatabaseInitialize); context.Configuration.AutoDetectChangesEnabled = autoDetectChangesEnabled; context.Configuration.ProxyCreationEnabled = proxyCreationEnabled; context.Configuration.LazyLoadingEnabled = lazyLoadingEnabled; context.Configuration.ValidateOnSaveEnabled = validateOnSaveEnabled; return(context); }
/// <summary> /// 현재 연결에서 database Transaction을 시작합니다. /// </summary> /// <param name="dbContext">The database context.</param> /// <param name="isolationLevel">The database isolation level with which the underlying store transaction will be created.</param> /// <returns>DbContextTransaction.</returns> public static DbContextTransaction BeginTransaction(this KatsContext dbContext, IsolationLevel isolationLevel) { return(dbContext.Database.BeginTransaction(isolationLevel)); }
/// <summary> /// 현재 연결에서 database Transaction을 시작합니다. /// </summary> /// <param name="dbContext">The database context.</param> /// <returns>DbContextTransaction.</returns> public static DbContextTransaction BeginTransaction(this KatsContext dbContext) { return(dbContext.Database.BeginTransaction()); }
/// <summary> /// Changes the connection string. /// </summary> /// <param name="server">The server.</param> /// <param name="port">The port.</param> public static void ChangeConnectionString(string server, uint port = Constants.DB_PORT) { var connectionString = KatsContext.GetConnectionString(server, port); ChangeConnectionString(KatsContext_NAME, connectionString); }