public IList <T> ExecuteSql <T>(string sql)
{
ISQLQuery sqlQuery = Sessao.CreateSQLQuery(sql);
sqlQuery.SetResultTransformer(NHibernate.Transform.Transformers.AliasToBean <T>());
return(sqlQuery.List <T>());
}
public void ExecuteProcedure(string procedure, Dictionary <string, object> parameters = null)
{
ISQLQuery sqlQuery = Sessao.CreateSQLQuery(procedure);
if (parameters != null)
{
foreach (var item in parameters)
{
sqlQuery.SetParameter(item.Key, item.Value);
}
}
sqlQuery.ExecuteUpdate();
}
public IList <T> ExecuteSql <T>(string sql, Dictionary <string, object> parameters = null)
{
ISQLQuery sqlQuery = Sessao.CreateSQLQuery(sql);
if (parameters != null)
{
foreach (var item in parameters)
{
sqlQuery.SetParameter(item.Key, item.Value);
}
}
sqlQuery.SetResultTransformer(NHibernate.Transform.Transformers.AliasToBean <T>());
return(sqlQuery.List <T>());
}