static void Main(string[] args) { String connString = @" Data Source=.; Initial Catalog=Samochody; Integrated Security=True "; DataContext sDataContext = new DataContext(connString); Table <Samochod> Samochody = sDataContext.GetTable <Samochod>(); if (sDataContext.DatabaseExists()) { Console.WriteLine("Deleting old database..."); sDataContext.DeleteDatabase(); } sDataContext.CreateDatabase(); // Insert Samochod s = new Samochod() { ID = 1, IDMarka = 1, Kolor = "Czarny" }; Samochody.InsertOnSubmit(s); sDataContext.SubmitChanges(); }
/// <summary> /// 创建数据库并更新版本 /// </summary> /// <param name="context"></param> private static void Create(DataContext context) { context.CreateDatabase(); var update = context.CreateDatabaseSchemaUpdater(); update.DatabaseSchemaVersion = Version; update.Execute(); }
public void CreateDataRepo() { using (DataContext context = DbContext.Create()) { if (!context.DatabaseExists()) { context.CreateDatabase(); } } }
public static DataContext dataContextByName(string db) { string conn = Config.CONNSTR(db); DataContext dc =new DataContext(conn); if (!dc.DatabaseExists()) { dc.CreateDatabase(); } return dc; }
protected override void CreateDatabase() { IConfiguration config = new BasicConfiguration(); var container = config.Container; DataContext context = container.Resolve <DataContext>(); if (context.DatabaseExists()) { context.DeleteDatabase(); } context.CreateDatabase(); }
protected void ReCreateDatabaseFromAttributeMapping(DataContext ctx) { bool success = false; bool retry = false; int retries = 0; do { try { using (ctx) { CloseAllOpenConnections(ctx); ctx.Log = new StringWriter(); if (ctx.DatabaseExists()) { //drop all connections by disabling multi-user (and immediatly abort all current transactions) ctx.ExecuteCommand("ALTER DATABASE " + _databaseName + " SET SINGLE_USER WITH ROLLBACK IMMEDIATE"); ctx.DeleteDatabase(); } try { ctx.CreateDatabase(); } catch (Exception e) { Debug.WriteLine(e); Debug.WriteLine(ctx.Log); throw; } //re-enable multi-user (again) ctx.ExecuteCommand("ALTER DATABASE " + _databaseName + " SET MULTI_USER"); success = true; } } catch (SqlException e) { retry = false; if (e.Message.IndexOf("was deadlocked on lock resources with another process and has been chosen as the deadlock victim") > 0) { retry = true; retries++; } } } while (success == false && (retry && retries < 3)); }
void ValidateDatabase() { if (!DataBaseContext.DatabaseExists()) { DataBaseContext.CreateDatabase(); CreateIndices(); } else { DataBaseContext.Connection.Open(); } if (!TableExists()) { CreateTable(); CreateIndices(); } }
private static void ClearTpDB(DataContext tpDatabaseDataContext) { if (!tpDatabaseDataContext.DatabaseExists()) { tpDatabaseDataContext.CreateDatabase(); tpDatabaseDataContext.SubmitChanges(); } else { tpDatabaseDataContext.ExecuteCommand("delete from Project"); tpDatabaseDataContext.ExecuteCommand("delete from TpUser"); tpDatabaseDataContext.ExecuteCommand("delete from General"); tpDatabaseDataContext.ExecuteCommand("delete from MessageUid"); tpDatabaseDataContext.ExecuteCommand("delete from PluginProfile"); tpDatabaseDataContext.ExecuteCommand("delete from Revision"); } }
private static void CreateDatabase() { DataContext.CreateDatabase(); }
/// <summary>Run operation.</summary> public void Run(enumRun mode) { // Validate application configuration file. if(String.IsNullOrEmpty(_paramGetStatusesSince) || String.IsNullOrEmpty(_paramGetStatusesCount)) { EventLog.WriteEntry(logName, "Application Error: Missing values from configuration file.", EventLogEntryType.Error); return; } // Init database. _dbContext = new BaseDataContext(_dbConnectionString); if(!_dbContext.DatabaseExists()) { _dbContext.CreateDatabase(); } // Create (INSERT) default data to database. if(mode == enumRun.LoadData) { CreateStatusesDefault(); Console.WriteLine("\nLoaded data successfully."); } else if(mode == enumRun.LoadData) { Console.WriteLine("\nCannot load data because it exists. If you want to try again, then you must either drop the database or delete all the records."); } // Iterate and process users. TwitterStatus userStatus = null; string userUrlGetStatuses = String.Empty; var userIds = _paramGetStatusesUserValue.RemoveWhitespaces().Split(new char[] {','}, StringSplitOptions.RemoveEmptyEntries); for(int i = 0;i < userIds.Length;i += 1) { userUrlGetStatuses = String.Empty; // Get (SELECT) status, most recent. userStatus = GetStatusLatest(userIds[i]); // Validate status. if(userStatus != null) { userUrlGetStatuses = _urlGetStatuses.AppendQueryString(String.Concat(_paramGetStatusesSince, "=", userStatus.Id)); } else { userUrlGetStatuses = _urlGetStatuses.AppendQueryString(String.Concat(_paramGetStatusesCount, "=", _paramDataStatusesHistory)); } // Create (INSERT) statue from XML. CreateStatus(userUrlGetStatuses.AppendQueryString(String.Concat(_paramGetStatusesUser, "=", userIds[i]))); } // Remove (DELETE) extra statuses based on maximum length. RemoveStatuses(_paramDataStatusesHistory); // Submit data changes. _dbContext.SubmitChanges(); }
/// <summary>Run operation.</summary> public void Run(enumRun mode) { // Init database. _dbContext = new BaseDataContext(_dbConnectionString); if(!_dbContext.DatabaseExists()) { _dbContext.CreateDatabase(); } // Get (SELECT) locations from database. var locations = GetLocations(); int locationsLength = locations.Count(); // Create (INSERT) default data to database. if(mode == enumRun.LoadData && (locations == null || locationsLength <= 0)) { locations = CreateLocationsDefault(); Console.WriteLine("\nLoaded data successfully."); } else if(mode == enumRun.LoadData) { Console.WriteLine("\nCannot load data because it exists. If you want to try again, then you must either drop the database or delete all the records."); } // Process condition from each location. for(int i = 0;i < locationsLength;i += 1) { // Create (INSERT) condition from XML. CreateConditions(locations[i]); // Remove (DELETE) extra conditions based on maximum length. RemoveConditions(locations[i], _paramConditionHistory); } // Remove (DELETE) extra conditions based on maximum length. RemoveConditions(_paramConditionHistory); // Submit data changes. _dbContext.SubmitChanges(); }