public void InsertProductEFSP() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); EntityFrameworkCoreData efData = new(connectionString); SqlCommandModel model = new() { CommandText = "EXEC InsertProduct @ProductName = {0}, @CategoryID = {1}, @SupplierID = {2}, @Discontinued = {3}", CommandType = CommandType.StoredProcedure, CommandParameters = new SqlCommandParameterModel[] { new SqlCommandParameterModel() { ParameterName = "@ProductName", DataType = DbType.String, Value = "Dapper Product Edited" } , new SqlCommandParameterModel() { ParameterName = "@CategoryID", DataType = DbType.Int32, Value = 1 } , new SqlCommandParameterModel() { ParameterName = "@SupplierID", DataType = DbType.Int32, Value = 1 } , new SqlCommandParameterModel() { ParameterName = "@Discontinued", DataType = DbType.Boolean, Value = false } } }; efData.ExecuteNonQuerySP(model); efData.Dispose(); }
public void InsertProductDDNSP() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); DapperDotNet ddnData = new(connectionString); SqlCommandModel model = new() { CommandText = "InsertProduct", CommandType = CommandType.StoredProcedure, CommandParameters = new SqlCommandParameterModel[] { new SqlCommandParameterModel() { ParameterName = "@ProductName", DataType = DbType.String, Value = "Dapper Product" } , new SqlCommandParameterModel() { ParameterName = "@CategoryID", DataType = DbType.Int32, Value = 1 } , new SqlCommandParameterModel() { ParameterName = "@SupplierID", DataType = DbType.Int32, Value = 1 } , new SqlCommandParameterModel() { ParameterName = "@Discontinued", DataType = DbType.Boolean, Value = false } } }; ddnData.ExecuteNonQuery(model); ddnData.Dispose(); }
/// <summary> /// This method reads the secrets from appsettings.json and sets them /// AppSettings are set in environment variables, ConfigurationManager.AppSettings /// ConnectionStrings are only set in ConfigurationManager.ConnectionStrings /// /// It also sets up a FileSystemWatcher that kills the current running process /// when appsettings.json is updated. /// </summary> private void ReadSecrets() { try { var secretsManager = new SecretsManager(); var secrets = secretsManager.GetSecrets(); UpdateEnvironmentVariables(secrets); UpdateAppSettings(secrets); UpdateConnectionStrings(secretsManager.GetConnectionStrings()); } catch (Exception e) { if (Environment.GetEnvironmentVariable(Constants.CliDebug) == "1") { ColoredConsole.Error.WriteLine(WarningColor(e.ToString())); } else { ColoredConsole.Error.WriteLine(WarningColor(e.Message)); } } fsWatcher = new FileSystemWatcher(Environment.CurrentDirectory, SecretsManager.AppSettingsFileName); fsWatcher.Changed += (s, e) => { Environment.Exit(ExitCodes.Success); }; fsWatcher.EnableRaisingEvents = true; }
public void ReadScalarProductEF() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); EntityFrameworkCoreData efData = new(connectionString); string productName = efData.Products.FirstOrDefault(p => p.ProductName.Contains("EF Product")).ProductName; efData.Dispose(); }
public void ReadScalarProductEFSP() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); EntityFrameworkCoreData efData = new(connectionString); string productName = efData.ExecuteScalarSP("EF Product"); efData.Dispose(); }
public void InsertProductDDN() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); DapperDotNet ddnData = new(connectionString); int recordsAffected = ddnData.ExecuteNonQuery("INSERT INTO Products (ProductName, CategoryID, SupplierId, Discontinued) VALUES('Dapper.NET Product', 1, 1, 0)"); ddnData.Dispose(); }
public void ReadFilteredProductADN() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); AdoDotNetData adnData = new(connectionString); IEnumerator <Product> data = adnData.ExecuteReader <Product>("SELECT * FROM Products WHERE ProductName LIKE 'ADO.NET Product'"); adnData.Dispose(); }
public void UpdateProductDDN() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); DapperDotNet ddnData = new(connectionString); int recordsAffected = ddnData.ExecuteNonQuery("UPDATE Products SET ProductName = 'Dapper.NET Product - Edited' WHERE ProductName = 'Dapper.NET Product'"); ddnData.Dispose(); }
public void ReadScalarProductADN() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); AdoDotNetData adnData = new(connectionString); string productName = adnData.ExecuteScalar <string>("SELECT TOP 1 ProductName FROM Products WHERE ProductName LIKE 'ADO.NET Product%'"); adnData.Dispose(); }
public void DeleteProductDDN() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); DapperDotNet ddnData = new(connectionString); int recordsAffected = ddnData.ExecuteNonQuery("DELETE FROM Products WHERE ProductName LIKE 'Dapper.NET Product%'"); ddnData.Dispose(); }
public void InsertProductADN() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); AdoDotNetData adnData = new(connectionString); adnData.ExecuteNonQuery("INSERT INTO Products (ProductName, CategoryID, SupplierId, Discontinued) VALUES('ADO.NET Product', 1, 1, 0)"); adnData.Dispose(); }
public void ReadFilteredProductsDDN() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); DapperDotNet ddnData = new(connectionString); IEnumerator <Product> data = ddnData.ExecuteReader <Product>("SELECT * FROM Products WHERE ProductName LIKE 'Dapper.NET Product%'"); ddnData.Dispose(); data.Dispose(); }
public void ReadFilteredProductsEFSP() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); EntityFrameworkCoreData efData = new(connectionString); IEnumerator <Product> products = efData.ExecuteReaderSP("EF Product"); efData.Dispose(); products.Dispose(); }
public void ReadFilteredProductsEF() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); EntityFrameworkCoreData efData = new(connectionString); IEnumerator <Product> products = efData.Products.Where(p => p.ProductName.Contains("EF Product")).GetEnumerator(); efData.Dispose(); products.Dispose(); }
public void InsertProductEF() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); EntityFrameworkCoreData efData = new(connectionString); Product product = new() { ProductName = "EF Product", CategoryID = 1, SupplierID = 1, Discontinued = false }; efData.Products.Add(product); efData.SaveChanges(); efData.Dispose(); }
public void DeleteProductEF() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); EntityFrameworkCoreData efData = new EntityFrameworkCoreData(connectionString); IQueryable <Product> products = efData.Products.Where(p => p.ProductName.Contains("EF Product")); efData.Products.RemoveRange(products); int recordsAffected = efData.SaveChanges(); efData.Dispose(); }
public void ReadScalarProductADNSP() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); AdoDotNetData aaa = new(connectionString); SqlCommandModel model = new SqlCommandModel() { CommandText = "GetProductName", CommandType = CommandType.StoredProcedure, CommandParameters = new SqlCommandParameterModel[] { new SqlCommandParameterModel() { ParameterName = "@ProductName", DataType = DbType.String, Value = "ADO.NET Product" } } }; string productName = aaa.ExecuteScalar <string>(model); aaa.Dispose(); }
public void ReadFilteredProductsDDNSP() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); DapperDotNet ddnData = new(connectionString); SqlCommandModel model = new() { CommandText = "GetProductName", CommandType = CommandType.StoredProcedure, CommandParameters = new SqlCommandParameterModel[] { new SqlCommandParameterModel() { ParameterName = "@ProductName", DataType = DbType.String, Value = "Dapper.NET Product" } } }; IEnumerator <Product> products = ddnData.ExecuteReaderSP <Product>(model); ddnData.Dispose(); }
public void DeleteProductADNSP() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); AdoDotNetData aaa = new(connectionString); SqlCommandModel model = new() { CommandText = "DeleteProduct", CommandType = CommandType.StoredProcedure, CommandParameters = new SqlCommandParameterModel[] { new SqlCommandParameterModel() { ParameterName = "@ProductName", DataType = DbType.String, Value = "ADO.NET Product - Edited" } } }; aaa.ExecuteNonQuery(model); aaa.Dispose(); }
public void DeleteProductEFSP() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); EntityFrameworkCoreData efData = new(connectionString); SqlCommandModel model = new() { CommandText = "EXEC DeleteProduct @ProductName = {0}", CommandType = CommandType.StoredProcedure, CommandParameters = new SqlCommandParameterModel[] { new SqlCommandParameterModel() { ParameterName = "@NewProductName", DataType = DbType.String, Value = "EF Product - Edited" } } }; efData.ExecuteNonQuerySP(model); efData.Dispose(); }
public void DeleteProductDDNSP() { string connectionString = SecretsManager.GetSecrets <DatabaseSettings>("ConnectionString"); DapperDotNet ddnData = new(connectionString); SqlCommandModel model = new() { CommandText = "DeleteProduct", CommandType = CommandType.StoredProcedure, CommandParameters = new SqlCommandParameterModel[] { new SqlCommandParameterModel() { ParameterName = "@ProductName", DataType = DbType.String, Value = "Dapper.NET Product - Edited" } } }; ddnData.ExecuteNonQuery(model); ddnData.Dispose(); } #endregion Dapper.NET Benchmarks }
public void GlobalSetup() { var connectionString = SecretsManager.GetSecrets <DatabaseSettings>(nameof(DatabaseSettings)).ConnectionString; _context = new DatabaseContext(connectionString); }