public async void UpdateBike() { var connection = new SqlConnection(Secrets.SqlString); var registerBike = QuickDapper.RegisterTable <Bike>(); Assert.NotNull(registerBike.QueryString); Assert.NotNull(registerBike.InsertString); var sampleBike = new Bike() { Model = "Z800", Manufacturer = "Kawasaki", Mileage = 0 }; var result = await connection.CreateAsync <Bike>(sampleBike); Assert.True(result > 0); var trashedZ = new UglyTrashedZ() //Really, who likes those bikes? { BikeNumber = 3, Mileage = 99999999 }; var update = await connection.UpdatePartialAsync <UglyTrashedZ>(trashedZ); Assert.True(update > 0); connection.Close(); }
public void RegisterPartial() { var registerBike = QuickDapper.RegisterTable <Bike>(); Assert.NotNull(registerBike.QueryString); Assert.NotNull(registerBike.InsertString); Assert.NotNull(registerBike.UpdateString); var registerMiniBike = QuickDapper.RegisterPartial <BikeMini>(); Assert.NotNull(registerMiniBike.QueryString); Assert.NotNull(registerMiniBike.InsertString); Assert.NotNull(registerMiniBike.UpdateString); }
public void RegisterTables() { var registerBike = QuickDapper.RegisterTable <Bike>(); Assert.NotNull(registerBike.QueryString); Assert.NotNull(registerBike.InsertString); Assert.NotNull(registerBike.UpdateString); var registerEvent = QuickDapper.RegisterTable <Event>(); Assert.NotNull(registerEvent.QueryString); Assert.NotNull(registerEvent.InsertString); Assert.NotNull(registerEvent.UpdateString); var registerTrack = QuickDapper.RegisterTable <Track>(); Assert.NotNull(registerTrack.QueryString); Assert.NotNull(registerTrack.InsertString); Assert.NotNull(registerTrack.UpdateString); }
public async void CreateBike() { var connection = new SqlConnection(Secrets.SqlString); var registerBike = QuickDapper.RegisterTable <Bike>(); Assert.NotNull(registerBike.QueryString); Assert.NotNull(registerBike.InsertString); var sampleBike = new Bike() { Model = "Z800", Manufacturer = "Kawasaki", Mileage = 0 }; var result = await connection.CreateAsync <Bike>(sampleBike); Assert.True(result > 0); connection.Close(); }
public async void SelectBike() { var connection = new SqlConnection(Secrets.SqlString); var registerBike = QuickDapper.RegisterTable <Bike>(); var registerMiniBike = QuickDapper.RegisterPartial <BikeMini>(); Assert.NotNull(registerBike.QueryString); Assert.NotNull(registerMiniBike.QueryString); var bikes = await connection.GetAll <Bike>(); var thundercat = await connection.FindOne <Bike>(1); var miniCat = await connection.FindOne <BikeMini>(1); Assert.NotNull(bikes); Assert.NotNull(thundercat); Assert.NotNull(miniCat); connection.Close(); }