/// <summary> /// Execute the queries in a transaction. The queries and parameters must have the same Dictionary Key. /// </summary> /// <param name="sqls"></param> /// <param name="param"></param> /// <returns></returns> /// <exception cref="SqlException"></exception> public int Transaction(DapperModel dapperModel, Dictionary <int, string> sqls, Dictionary <int, object> param = null) { int result = 0; List <DapperSimpleQuery> queries = new List <DapperSimpleQuery>(); if (param == null) { foreach (KeyValuePair <int, string> sql in sqls) { queries.Add(new DapperSimpleQuery(sql.Value, null)); } } else { foreach (KeyValuePair <int, string> sql in sqls) { queries.Add(new DapperSimpleQuery(sql.Value, param[sql.Key])); } } try{ result = dapperModel.Transaction(queries); } catch (SqlException ex) { throw ex; } return(result); }
/// <summary> /// Execute many diference sql statement on DB. /// </summary> /// <param name="queries"></param> /// <param name="parameters"></param> /// <returns></returns> public SqlMapper.GridReader QueryMultiple(DapperModel dapperModel, List <string> queries, object parameters = null) { SqlMapper.GridReader result = null; try { result = dapperModel.QueryMultiple(queries, parameters); } catch (Exception ex) { throw ex; } return(result); }
/// <summary> /// Execute Select statement and return <see langword="T"/> object mapping the column table with <see langword="T"/> object properties. /// </summary> /// <typeparam name="T"></typeparam> /// <param name="Connection"></param> /// <param name="sql"></param> /// <param name="param"></param> /// <returns></returns> /// <exception cref="Exception"></exception> public IEnumerable <T> Query <T>(SqlConnection Connection, string sql, object param = null) { IEnumerable <T> result = null; try { result = DapperModel.Query <T>(Connection, sql, param); } catch (Exception ex) { throw ex; } return(result); }
/// <summary> /// Query method can execute a query and map the result to a strongly typed list with a one to many relations or none to one relations. /// </summary> /// <typeparam name="TFirst"></typeparam> /// <typeparam name="TSecond"></typeparam> /// <typeparam name="TReturn"></typeparam> /// <param name="sql"></param> /// <param name="map"></param> /// <param name="param"></param> /// <param name="buffered"></param> /// <param name="splitOn"></param> /// <param name="commandType"></param> /// <param name="dapperModel"></param> /// <returns></returns> /// <exception cref="Exception"/> /// <example> /// <code> /// (One to One) /// var invoices = connection.Query<Invoice, InvoiceDetail, Invoice>( /// sql, /// (invoice, invoiceDetail) => /// { /// invoice.InvoiceDetail = invoiceDetail; /// return invoice; /// }, /// splitOn: "InvoiceID") /// .Distinct() /// .ToList(); /// /// (One to Many) /// var orderDictionary = new Dictionary<int, Order>(); /// /// var list = connection.Query<Order, OrderDetail, Order>( /// sql, /// (order, orderDetail) => /// { /// Order orderEntry; /// /// if (!orderDictionary.TryGetValue(order.OrderID, out orderEntry)) /// { /// orderEntry = order; /// orderEntry.OrderDetails = new List<OrderDetail>(); /// orderDictionary.Add(orderEntry.OrderID, orderEntry); /// } /// /// orderEntry.OrderDetails.Add(orderDetail); /// return orderEntry; /// }, /// splitOn: "OrderDetailID") /// .Distinct() /// .ToList(); /// </code> /// </example> public IEnumerable <TReturn> Query <TFirst, TSecond, TReturn>(DapperModel dapperModel, string sql, Func <TFirst, TSecond, TReturn> map, object param = null, string splitOn = null) { IEnumerable <TReturn> result = null; try { result = dapperModel.Query <TFirst, TSecond, TReturn>(sql, map, param, splitOn); } catch (Exception ex) { throw ex; } return(result); }
/// <summary> /// Delete DB row /// </summary> /// <param name="sql"></param> /// <param name="param"></param> /// <returns></returns> /// <exception cref="Exception"></exception> public int StorageProcedure(DapperModel dapperModel, string sql, object param = null) { int result = 0; try { result = dapperModel.Execute(sql, param, CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } return(result); }
/// <summary> /// Delete DB row /// </summary> /// <param name="sql"></param> /// <param name="param"></param> /// <returns></returns> /// <exception cref="Exception"></exception> public int Delete(DapperModel dapperModel, string sql, object param = null) { int result = 0; try { result = dapperModel.Execute(sql, param); } catch (Exception ex) { throw ex; } return(result); }
/// <summary> /// Execute statement select on DB and return first or default anonymous result /// </summary> /// <typeparam name="T"></typeparam> /// <param name="sql"></param> /// <param name="param"></param> /// <returns></returns> /// <exception cref="Exception"></exception> public T QueryFirstOrDefault <T>(DapperModel dapperModel, string sql, object param = null) { T result = default(T); try { result = dapperModel.QueryFirstOrDefault <T>(sql, param); } catch (Exception ex) { throw ex; } return(result); }
/// <summary> /// Execute statement select on DB and return anonymous result /// </summary> /// <param name="sql"></param> /// <param name="param"></param> /// <returns></returns> /// <exception cref="Exception"></exception> public IEnumerable <dynamic> Query(DapperModel dapperModel, string sql, object param = null) { IEnumerable <dynamic> result = null; try { result = dapperModel.Query(sql, param); } catch (Exception ex) { throw ex; } return(result); }
/// <summary> /// /// </summary> /// <param name="dapperModel"></param> /// <returns></returns> public bool ThereIsConectivity(DapperModel dapperModel) { return(dapperModel.ThereIsConectivity()); }