public void S_DataObject_Should_CRUD_An_Item_With_Shared_Transactional_Data_Context() { using (var context = new DataContext()) { var dodge = new Manufacturer { Name = "Dodge", BuildYear = 1900 }; manufacturerDataObject.Insert(dodge, context); dodge.BuildYear = 1915; manufacturerDataObject.Update(dodge, context); var updatedDodge = context.First<Manufacturer>("SELECT TOP 1 * FROM Le_Manufacturer WHERE Name = 'Dodge'"); var m4s = new Car { Name = "M4S", ModelYear = 1984, Category = CarCategory.Prototype, ManufacturerId = dodge.TheId }; carDataObject.Insert(m4s, context); var createdM4s = carDataObject.Select.With(context).First("WHERE Name = 'M4S'"); carDataObject.Delete(m4s, context); var deletedM4s = carDataObject.Select.With(context).First("WHERE Name = 'M4S'"); updatedDodge.BuildYear.Should().Be(1915); createdM4s.Should().NotBeNull(); deletedM4s.Should().BeNull(); context.Commit(); } var createdDodgeOutsiteContext = manufacturerDataObject.Select.First("WHERE Name = 'Dodge'"); createdDodgeOutsiteContext.Should().NotBeNull(); }
public void C_DataContext_Non_Transitional_Should_Execute_A_Insert_SQL_Command_With_Object_Parameters_And_Read_Created_Data_In_Same_And_Count_Data() { using (var context = new DataContext(Transaction.No)) { var insertParameters = new Manufacturer { Name = "General Motors", BuildYear = 1908 }; context.Execute("INSERT INTO Le_Manufacturer VALUES (@Name, @BuildYear)", insertParameters); var manufacturer = context.First<Manufacturer>("SELECT * FROM Le_Manufacturer WHERE BuildYear = 1908"); var manufacturerCount = context.GetValue<int>("SELECT COUNT(TheId) FROM Le_Manufacturer"); manufacturer.TheId.Should().BeGreaterThan(0); manufacturer.Name.Should().Be("General Motors"); manufacturer.BuildYear.Should().Be(1908); manufacturerCount.Should().Be(3); } }
public void O_DataObject_Should_Create_Item_From_Database_With_Custom_Table_Name_And_Primary_Key() { var manufacturer = new Manufacturer { Name = "Lamborghini", BuildYear = 1963 }; manufacturerDataObject.Insert(manufacturer); var queryParams = new { Name = "Lamborghini" }; var createdManufacturer = manufacturerDataObject.Select.First("WHERE Name = @Name", queryParams); manufacturer.TheId.Should().BeGreaterThan(0); createdManufacturer.Name.Should().Be("Lamborghini"); createdManufacturer.BuildYear.Should().Be(1963); }