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(); }
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 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 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 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 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 }