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