static bool TableExists(string tableName)
{
bool exists = false;
string select = ""
+ "SELECT * FROM INFORMATION_SCHEMA.TABLES "
+ "WHERE TABLE_SCHEMA = 'dbo' "
+ "AND TABLE_NAME = '{0}'";
string sql = string.Format(select, tableName);
var Model = new PGTable<dynamic>(_connectionStringName);
var query = Model.Query<dynamic>(sql);
if (query.Count() > 0) {
exists = true;
}
return exists;
}
bool TableExists(string tableName)
{
bool exists = false;
string select = ""
+ "SELECT * FROM information_schema.tables "
+ "WHERE table_schema = 'public' "
+ "AND table_name = '{0}'";
string sql = string.Format(select, tableName);
var Model = new PGTable<dynamic>(_connectionStringName);
var query = Model.Query<dynamic>(sql);
if (query.Count() > 0)
{
exists = true;
}
return exists;
}
