| private DoesColumnExists ( IDbConnection conn, string tableName, string columnName ) : bool | ||
| conn | IDbConnection | |
| tableName | string | |
| columnName | string | |
| Résultat | 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();
}
}