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; }