private static bool CheckTableExists(Schema schema)
{
string sql = string.Format(@"SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '{0}'", schema.GetTableName());
SqlCommand command = new SqlCommand()
{
CommandText = sql
};
return((int)SQLServerHelper.ExecuteScalar(schema.Repository, command) != 0);
}
public object ExecuteScalar(Repository repository, string queryText, System.Data.CommandType commandType = System.Data.CommandType.Text, params KeyValuePair <string, object>[] parameters)
{
var command = new System.Data.SqlClient.SqlCommand(queryText);
if (parameters != null && parameters.Length > 0)
{
command.Parameters.AddRange(parameters.Select(it => new SqlParameter()
{
ParameterName = it.Key, Value = it.Value
}).ToArray());
}
command.CommandType = commandType;
return(SQLServerHelper.ExecuteScalar(repository, command));
}
