public void DBgen() { SQL_CONTEXT db = new SQL_CONTEXT(); if (!db.Database.Exists()) { db.Database.Delete(); db.SaveChanges(); db.Database.CreateIfNotExists(); db.SaveChanges(); } }
public static void migrate(string tableName, DateTime dateFrom, DateTime dateTo) { StringsToCommand st = Connections.stringsToCommand.Where(s => s.TableName == tableName).FirstOrDefault(); ORCLconn.ConnectionString = Connections.ORCLconnectionString .Replace(@":userID", @"neprintsev_ia") .Replace(@":password", @"awsedrDRSEAW"); ORCLconn.Open(); SQLconn.ConnectionString = @"data source=.\SQLEXPRESS;initial catalog=DWH_REPLICA;integrated security=True;"; SQLconn.Open(); OracleCommand oSelcomm = new OracleCommand(st.ORCLSelectCommand, ORCLconn); SqlCommand sDelcomm = new SqlCommand(st.SQLDeleteCommand, SQLconn); SqlCommand sInscomm = new SqlCommand(st.SQLInsertCommand, SQLconn); oSelcomm.Parameters.Add("DateFrom", OracleDbType.Date); oSelcomm.Parameters.Add("DateTo", OracleDbType.Date); oSelcomm.Parameters["DateFrom"].Value = dateFrom; oSelcomm.Parameters["DateTo"].Value = dateTo; sDelcomm.Parameters.Add("DateFrom", SqlDbType.DateTime); sDelcomm.Parameters.Add("DateTo", SqlDbType.DateTime); sDelcomm.Parameters["DateFrom"].Value = dateFrom; sDelcomm.Parameters["DateTo"].Value = dateTo; if (Connections.stringsToCommand.Select(s => s.TableName == tableName) != null) { sDelcomm.ExecuteNonQuery(); OracleDataReader reader = oSelcomm.ExecuteReader(); SQL_CONTEXT db = new SQL_CONTEXT(); if (tableName == "FD_ACQ_D") { sInscomm.Parameters.Add("dt_trn", SqlDbType.Date); sInscomm.Parameters.Add("dt_reg", SqlDbType.Date); sInscomm.Parameters.Add("acquire_bank", SqlDbType.Char); sInscomm.Parameters.Add("pay_sys", SqlDbType.Char); sInscomm.Parameters.Add("issuer_type", SqlDbType.Char); sInscomm.Parameters.Add("type_transaction", SqlDbType.Char); sInscomm.Parameters.Add("tran_name", SqlDbType.Char); sInscomm.Parameters.Add("merchantID", SqlDbType.Char); sInscomm.Parameters.Add("terminal_type", SqlDbType.Char); sInscomm.Parameters.Add("is_linked", SqlDbType.Char); sInscomm.Parameters.Add("amt", SqlDbType.Decimal); sInscomm.Parameters.Add("fee", SqlDbType.Decimal); sInscomm.Parameters.Add("cnt", SqlDbType.BigInt); } while (reader.Read()) { var b = reader[12].GetType(); sInscomm.Parameters["dt_trn"].Value = (DateTime)reader[0]; sInscomm.Parameters["dt_reg"].Value = (DateTime)reader[1]; sInscomm.Parameters["acquire_bank"].Value = (string)reader[2]; sInscomm.Parameters["pay_sys"].Value = (string)reader[3]; sInscomm.Parameters["issuer_type"].Value = (string)reader[4]; sInscomm.Parameters["type_transaction"].Value = (string)reader[5]; sInscomm.Parameters["tran_name"].Value = (string)reader[6]; sInscomm.Parameters["merchantID"].Value = (string)reader[7]; sInscomm.Parameters["terminal_type"].Value = (string)reader[8]; sInscomm.Parameters["is_linked"].Value = (string)reader[9]; sInscomm.Parameters["amt"].Value = (double)reader[10]; sInscomm.Parameters["fee"].Value = (double)reader[11]; sInscomm.Parameters["cnt"].Value = (Int64)reader[12]; sInscomm.ExecuteNonQuery(); } } }