public static void PurgeDb(Seed seed)
{
ConnectionProfile cp = new ConnectionProfile();
SqlConnectionStringBuilder conn_orig = new SqlConnectionStringBuilder(cp.ConnectionString);
SqlConnectionStringBuilder conn = new SqlConnectionStringBuilder(cp.ConnectionString) { ConnectTimeout = 5, InitialCatalog = "master" }; // you can add other parameters.
using (SqlConnection cnn = new SqlConnection(conn.ConnectionString))
{
cnn.Open();
using (SqlCommand dbCreate = new SqlCommand())
{
dbCreate.CommandText = string.Format(@"IF db_id('{0}') IS NULL CREATE DATABASE [{0}]", conn_orig.InitialCatalog);
dbCreate.Connection = cnn;
try
{
dbCreate.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(string.Format("create database [{0}] FAILED with {1}", conn_orig.InitialCatalog, ex.Message ));
}
}
}
seed.PurgeDb();
}
public Seed(ConnectionProfile connectionProfile)
{
if (connectionProfile == null)
{
connectionProfile = new ConnectionProfile();
}
ConnectionProfile = connectionProfile;
}
public static void InsertInto(this object o, string table, ConnectionProfile connectionProfile = null)
{
if (connectionProfile == null) connectionProfile = new ConnectionProfile();
DynamicModel dynamicModel = new DynamicModel(connectionProfile, table, "Id");
dynamicModel.Insert(o);
}
public static object InsertInto(this object o, string table, ConnectionProfile connectionProfile = null)
{
if (connectionProfile == null) connectionProfile = new ConnectionProfile();
DynamicRepository dynamicModel = new DynamicRepository(connectionProfile, table, "Id");
return dynamicModel.Insert(o);
}
public static SqlDataReader ExecuteReader(this string query, ConnectionProfile connectionProfile = null)
{
if (connectionProfile == null) connectionProfile = new ConnectionProfile();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = new SqlConnection(connectionProfile.ConnectionString);
sqlCommand.Connection.Open();
sqlCommand.CommandText = String.Format(query);
return sqlCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
public static object InsertInto(this object o, string table, ConnectionProfile connectionProfile = null)
{
if (connectionProfile == null)
{
connectionProfile = new ConnectionProfile();
}
DynamicRepository dynamicModel = new DynamicRepository(connectionProfile, table, "Id");
return(dynamicModel.Insert(o));
}
public static void ExecuteNonQuery(this string query, ConnectionProfile connectionProfile = null)
{
if (connectionProfile == null) connectionProfile = new ConnectionProfile();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = new SqlConnection(connectionProfile.ConnectionString);
sqlCommand.Connection.Open();
sqlCommand.CommandText = String.Format(query);
sqlCommand.ExecuteNonQuery();
sqlCommand.Connection.Close();
}
public DynamicRepository(ConnectionProfile connectionProfile, string tableName = "", string primaryKeyField = "")
{
TableName = tableName == "" ? this.GetType().Name : tableName;
PrimaryKeyField = string.IsNullOrEmpty(primaryKeyField) ? "Id" : primaryKeyField;
var _providerName = "System.Data.SqlClient";
_factory = DbProviderFactories.GetFactory(_providerName);
if (connectionProfile == null) connectionProfile = new ConnectionProfile();
ConnectionProfile = connectionProfile;
Projection = (d) => d;
}
public static object ExecuteScalar(this string query, ConnectionProfile connectionProfile = null)
{
if (connectionProfile == null) connectionProfile = new ConnectionProfile();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = new SqlConnection(connectionProfile.ConnectionString);
sqlCommand.Connection.Open();
sqlCommand.CommandText = String.Format(query);
var result = sqlCommand.ExecuteScalar();
sqlCommand.Connection.Close();
return result;
}
public static SqlDataReader ExecuteReader(this string query, ConnectionProfile connectionProfile = null)
{
if (connectionProfile == null)
{
connectionProfile = new ConnectionProfile();
}
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = new SqlConnection(connectionProfile.ConnectionString);
sqlCommand.Connection.Open();
sqlCommand.CommandText = String.Format(query);
return(sqlCommand.ExecuteReader(CommandBehavior.CloseConnection));
}
public static void ExecuteNonQuery(this string query, ConnectionProfile connectionProfile = null)
{
if (connectionProfile == null)
{
connectionProfile = new ConnectionProfile();
}
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = new SqlConnection(connectionProfile.ConnectionString);
sqlCommand.Connection.Open();
sqlCommand.CommandText = String.Format(query);
sqlCommand.ExecuteNonQuery();
sqlCommand.Connection.Close();
}
static void Main(string[] args)
{
if (args.Length == 0) throw new InvalidOperationException("first argument should be a connection string.");
Console.WriteLine("Purging and regenerating schema for " + args[0] + ".");
var connection = new ConnectionProfile { ConnectionString = args[0] };
var seed = new Seed(connection);
var schema = new Schema(seed);
seed.PurgeDb();
seed.ExecuteTo(schema.Scripts(), schema.Current());
Console.WriteLine("Done.");
}
public static object ExecuteScalar(this string query, ConnectionProfile connectionProfile = null)
{
if (connectionProfile == null)
{
connectionProfile = new ConnectionProfile();
}
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = new SqlConnection(connectionProfile.ConnectionString);
sqlCommand.Connection.Open();
sqlCommand.CommandText = String.Format(query);
var result = sqlCommand.ExecuteScalar();
sqlCommand.Connection.Close();
return(result);
}
public Seed(ConnectionProfile connectionProfile)
{
if (connectionProfile == null) connectionProfile = new ConnectionProfile();
ConnectionProfile = connectionProfile;
}
public DynamicDb()
{
connectionString = new ConnectionProfile().ConnectionString;
}
