public bool TableExist(string tableName, string connectionName = null)
{
string sqlTemplate = "SELECT COUNT(*) FROM dbo.sysobjects WHERE name = '{0}'";
string sqlText = string.Format(sqlTemplate, tableName);
string connStr = SqlServerConnectionProvider.Instance.GetConnectionString(connectionName);
object result = SqlServerBaseOrder.ExecuteScalar(connStr, sqlText);
return((int)result > 0 ? true : false);
}
public bool DatabaseExist(string connectionName = null)
{
string databaseName = ConnectionProviderBase.GetDatabaseName(connectionName);
string sqlTemplate = "SELECT * FROM master.dbo.sysdatabases WHERE name='{0}'";
string sqlText = string.Format(sqlTemplate, databaseName);
string connStr = SqlServerConnectionProvider.Instance.GetConnectionStringWithoutIC(connectionName);
object result = SqlServerBaseOrder.ExecuteScalar(connStr, sqlText);
if (result != null && string.Equals(result as string, databaseName))
{
return(true);
}
return(false);
}
