public static void ReCreateProcedureIfInsertExists(dynamic dynamic)
{
SqlCommand command = new SqlCommand("", Connected.Connection);
var query = InsertProcedure.Insert(dynamic, "ALTER");
Commond.ExecuteQueryForText(command, query);
}
public static void Database(string name)
{
string conn = "Server=.;Initial Catalog=master;Integrated Security=True";
SqlConnection Connection = new SqlConnection(conn);
string query = $"CREATE DATABASE {name} ";
SqlCommand command = new SqlCommand(query, Connection);
command.CommandType = CommandType.Text;
Commond.ExecuteQueryForText(command);
WriteDbNameToFile(name);
}
public static bool CreateTable <T>(string name) where T : class
{
SqlConnection sqlConnection = new SqlConnection($"Data Source=.;Initial Catalog={name};Integrated Security=True");
var quers = DbQuery <T> .Table(GetDbNameFromFile());
SqlCommand command = new SqlCommand();
command.Connection = sqlConnection;
command.CommandType = CommandType.Text;
command.CommandText = quers;
return(Commond.ExecuteQueryForText(command));
}
private static bool commoned(dynamic dynamic, string query)
{
SqlCommand command = new SqlCommand("", Connected.Connection);
return(Commond.ExecuteQueryForText(command, query));
}