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