static void Main(string[] args) { Options.ConnectionOptions connectionOptions = new Options.ConnectionOptions(); DataAccessLayer dataAccessLayer = new DataAccessLayer(connectionOptions); Console.WriteLine("Hello World!"); Console.ReadKey(); }
public DataAccessLayer(Options.ConnectionOptions options) { string connectionStr = $"Data Source={options.DataSource};" + $" Database={options.DataBase}; " + $"Integrated Security={options.IntegratedSecurity};" + $"Pooling={options.Pooling}"; using (TransactionScope scope = new TransactionScope()) { connection = new SqlConnection(connectionStr); connection.Open(); scope.Complete(); } }