public static int Execute(this IDbConnection dbconnection, ISQLinq query,
IDbTransaction transaction = null, int?commandTimeout = null, CommandType?commandType = null)
{
var result = query.ToSQL();
var sql = result.ToQuery();
var parameters = new DictionaryParameterObject(result.Parameters);
return(DapperDotNet.SqlMapper.Execute(dbconnection, sql, parameters, transaction, commandTimeout, commandType));
}
public static IEnumerable <dynamic> Query(this IDbConnection dbconnection, ISQLinq query,
IDbTransaction transaction = null, bool buffered = true, int?commandTimeout = null, CommandType?commandType = null)
{
var result = query.ToSQL();
var sql = result.ToQuery();
var parameters = new DictionaryParameterObject(result.Parameters);
return(DapperDotNet.SqlMapper.Query(dbconnection, sql, parameters, transaction, buffered, commandTimeout, commandType));
}
public static TIdentity Execute <TIdentity>(this IDbConnection dbconnection, ISQLinqInsert query,
IDbTransaction transaction = null, int?commandTimeout = null, CommandType?commandType = null)
{
var result = query.ToSQL();
var sql = result.ToQuery();
var parameters = new DictionaryParameterObject(result.Parameters);
using (
var reader = DapperDotNet.SqlMapper.ExecuteReader(dbconnection, sql, parameters, transaction,
commandTimeout, commandType))
{
if (reader.Read() && !reader.IsDBNull(0))
{
var value = reader.GetValue(0);
reader.Close();
return((TIdentity)Convert.ChangeType(value, typeof(TIdentity)));
}
return(default(TIdentity));
}
}
