public static bool ObjectExistsInDatabase(string connectionString, string objectName)
{
string sql = String.Format("SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'{0}')", objectName);
DataTable table
= SimpleDataAccess.ExecuteDataTable(cmd => {
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
},
connectionString);
return(table.Rows.Count > 0);
}
public bool ObjectExists(string tableName, DbObjectType objectType)
{
string sql = ObjectExistsSql(tableName, objectType);
DataTable table
= SimpleDataAccess.ExecuteDataTable(cmd => {
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
},
ConnectionString);
return(table.Rows.Count > 0);
}
public int NextId()
{
string sql = string.Format("EXEC dbo.{0} {1}, {2}",
GetNextIdProcName,
WhereStatement.FormatSqlValue(_objectType),
WhereStatement.FormatSqlValue(1));
DataTable result = SimpleDataAccess.ExecuteDataTable(command => {
command.CommandType = CommandType.Text;
command.CommandText = sql;
},
_connection);
DataRow row = result.AsEnumerable().Single();
return(row.Field <int>(0));
}
/// <summary>
/// Can we connect to the specified database
/// </summary>
/// <param name="connectionString">The SQL connection string</param>
/// <param name="databaseName">The server name</param>
/// <returns>true if we can connect to the database</returns>
public static bool DatabaseExists(string connectionString, string databaseName)
{
try
{
DataTable dt = SimpleDataAccess.ExecuteDataTable(cmd => {
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT ISNULL(HAS_DBACCESS('" + databaseName + "'),-2) AS ReturnValue";
},
connectionString);
if (dt.Rows.Count == 0)
{
return(false);
}
DataRow dr = dt.Rows[0];
if (dr.ItemArray.GetValue(0).ToString() == "-2")
{
return(false);
}
else if (dr.ItemArray.GetValue(0).ToString() == "0")
{
return(false);
}
else if (dr.ItemArray.GetValue(0).ToString() == "1")
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
}
