//This Method is only an example of syntax private static void ExampleTransaction() { using (var dapper = new DapperBase()) { try { dapper.StartTransaction(); var cars = new Car().GetCarsDefault(); foreach (var car in cars) { dapper.SetExecuteInTransaction <object>("InsertProdecureExample", new { car.Brand, car.Model, car.Color }); } dapper.CommitTransaction(); } catch (Exception ex) { dapper.RollbackTransaction(); throw ex; } } }
public DataRepo(DatabaseConfig databaseConfig) { _databaseConfig = databaseConfig; Dapper = new DapperBase(databaseConfig); _initializationTime = DateTime.Now; HandleYearDapper(); }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); if (!Directory.Exists("Images")) { try { Directory.CreateDirectory("Images"); } catch (Exception e) { MessageHelper.DisplayError(e.Message); } } Application.SetUnhandledExceptionMode(UnhandledExceptionMode.CatchException); Application.ThreadException += Application_ThreadException; AppDomain.CurrentDomain.UnhandledException += CurrentDomain_UnhandledException; var d = new DapperBase <BaseEntity>(); if (!d.TryOpenConenction()) { MessageHelper.DisplayError("Can't connect to database"); return; } Application.Run(new mainForm()); }