private Tuple <string, MySqlCommand> Create__WORM__Configuration_Table(string tablesXMLForm) { string configurationTableQuery = $"CREATE TABLE IF NOT EXISTS __worm__configuration ( " + "Version int NOT NULL AUTO_INCREMENT," + "UpdatedTime DATETIME," + "UpdatedAuthor VARCHAR(255)," + "TablesXMLForm MEDIUMTEXT," + "PRIMARY KEY (Version) " + ");"; DBInformationModel dBInformationModel = DBConnectionFactory.ReturnDBInformatinFromXML(this.ContextName); MySqlCommand command = new MySqlCommand($"INSERT INTO __worm__configuration(UpdatedTime, UpdatedAuthor, TablesXMLForm) " + $"VALUES(@UpdatedTime,@UpdatedAuthor,@TablesXMLForm)", (MySqlConnection)connection); command.Parameters.AddWithValue("@UpdatedTime", DateTime.Now); command.Parameters.AddWithValue("@UpdatedAuthor", dBInformationModel.UpdatedAuthor); command.Parameters.AddWithValue("@TablesXMLForm", tablesXMLForm); return(Tuple.Create(configurationTableQuery, command)); }
private Tuple <string, SqlCommand> Create__WORM__Configuration_Table(string tablesXMLForm) { string configurationTableQuery = $"IF NOT EXISTS (SELECT * FROM sys.tables WHERE name = N'__WORM__Configuration')" + "BEGIN " + "CREATE TABLE [dbo].[__WORM__Configuration]( " + "Version int IDENTITY(1,1) PRIMARY KEY," + "UpdatedTime datetime," + "UpdatedAuthor nvarchar(200)," + "TablesXMLForm nvarchar(max)" + ") END"; DBInformationModel dBInformationModel = DBConnectionFactory.ReturnDBInformatinFromXML(this.ContextName); SqlCommand command = new SqlCommand($"INSERT INTO [dbo].[__WORM__Configuration](UpdatedTime, UpdatedAuthor, TablesXMLForm) " + $"VALUES(@UpdatedTime,@UpdatedAuthor,@TablesXMLForm)", (SqlConnection)connection); command.Parameters.AddWithValue("@UpdatedTime", DateTime.Now); command.Parameters.AddWithValue("@UpdatedAuthor", dBInformationModel.UpdatedAuthor); command.Parameters.AddWithValue("@TablesXMLForm", tablesXMLForm); return(Tuple.Create(configurationTableQuery, command)); }
public DB_Operation(string contextName) { this.contextName = contextName; connectionString = DBConnectionFactory.ReturnDBInformatinFromXML(contextName).ConnectionString; connectionStringWithDB = connectionString + $"Database={contextName};"; }