private DoesColumnExists ( IDbConnection conn, string tableName, string columnName ) : bool | ||
conn | IDbConnection | |
tableName | string | |
columnName | string | |
Результат | bool |
private bool DoesColumnExists(IDbConnection conn, string tableName, string columnName)
{
var query = $@"SELECT 1
FROM information_schema.COLUMNS
WHERE
TABLE_SCHEMA = '{_databaseName}'
AND TABLE_NAME = '{tableName}'
AND COLUMN_NAME = '{columnName}'";
return conn.Query(query).Any();
}
}