public void TestMethod1()
{
/// Setup
var queryChain = new QueryChain();
var schema = new Schema(queryChain);
var request = schema.CspExampleStoredProcedure(1);
/// Usage
// Non-query
request.NonQuery();
// Scalar
var scalar = request.Scalar <int>();
// Query
var result = request.Query <SampleDto1>();
var item1 = result.First();
// Multiple
using (var reader = request.Multiple())
{
var result1 = reader.Read <SampleDto1>();
var item2 = result1.First();
var result2 = reader.Read <SampleDto2>();
var item3 = result2.First();
}
// Output parameter
var id = new OutputParameter <int>(1);
schema.CspWithOutputParameter(id).Query <SampleDto1>();
}
static void Main(string[] args)
{
var queryChain = new QueryChain()
.UseConsoleLogger()
.UseDapper(new Flyingpie.Storm.Dapper.DapperConfiguration()
{
ConnectionStringName = "DataAccessDemo"
});
var demo = new Demo(queryChain);
// Deze code tijdens demo opbouwen
/// 2. NonQuery ///////////////////////
//demo.AddBrand("Opel", "Wir leben autos", "Germany", new DateTime(1862, 1, 21)).NonQuery();
/// 1. Query //////////////////////////
//var brands = demo.GetAllBrands().Query<Brand>();
//foreach (var brand in brands)
//{
// Console.WriteLine(brand.Id + " " + brand.Name + " " + brand.Founded.ToShortDateString() + " " + brand.Country + " " + brand.Slogan);
//}
/// 3. Udt's //////////////////////////
//var models = new List<UdtModel>()
//{
// new UdtModel()
// {
// BrandId = 6,
// Name = "Vectra",
// HorsePower = 80,
// Year = 1988
// },
// new UdtModel()
// {
// BrandId = 6,
// Name = "Ascona",
// HorsePower = 90,
// Year = 1981
// }
//};
//demo.BulkAddModels(models).NonQuery();
/// 5. Multiple result sets /////////////
//using (var result = demo.GetAllBrandsAndModels().Multiple())
//{
// var brands = result.Read<Brand>();
// var models = result.Read<Model>();
//}
/// 6. Middleware ///////////////////////
var models2 = demo.GetModelsByMinimumYearAndMinimumHorsePower(1980, 100).Query<Model>();
}
public void MyTestMethod()
{
var queryChain = new QueryChain();
queryChain
.UseConsoleLogger()
.UseDapper(new DapperConfiguration()
{
ConnectionString = "server=storm.database.windows.net;database=Storm;user=storm;password=WRQLgVSsAHy2W8pHe6T4;"
});
//var data = new Data(queryChain);
// Query
//var result = data.CspInstantieS01(null, null, null, null, null, null).Query<InstantieDto>();
// Multiple
//using (var reader = data.CspWithMultipleResultSets(null).Multiple())
//{
// var result1 = reader.Read<InstantieDto>();
// var result2 = reader.Read<GebruikerDto>();
//}
}
