public void GetAllStatuses_ReturnsResults() { DatabaseBootstrapper.CreateAndPopulate(); DataTable dataTable = QueryRunner.ExecuteStoredProcedure("uspGetAllStatuses"); DatabaseBootstrapper.Drop(); Assert.True(dataTable.Rows.Count > 0); }
public void GetAllStatuses_ReturnsResults_ThrowsOnExtraProperty() { DatabaseBootstrapper.CreateAndPopulate(); DataTable dataTable = QueryRunner.ExecuteStoredProcedure("uspGetAllStatuses"); DatabaseBootstrapper.Drop(); DataTableConverter dtp = new DataTableConverter(); dtp.DataTableParserSettings.MissingMappingHandling = MissingMappingHandling.Error; Assert.Throws <MissingMappingException <StatusExtraProperty> >(() => dtp.ConvertToObjectList <StatusExtraProperty>(dataTable)); }
public void GetAllStatuses_ReturnsResults_CanBeParsedWithMissingFields() { DatabaseBootstrapper.CreateAndPopulate(); DataTable dataTable = QueryRunner.ExecuteStoredProcedure("uspGetAllStatuses"); DatabaseBootstrapper.Drop(); DataTableConverter dtp = new DataTableConverter(); var results = dtp.ConvertToObjectList <StatusPropertyNameMissing>(dataTable); Assert.Equal(dataTable.Rows.Count, results.Count()); }
public void GetAllStatuses_ReturnsResults_IgnoresExtraProperty() { DatabaseBootstrapper.CreateAndPopulate(); DataTable dataTable = QueryRunner.ExecuteStoredProcedure("uspGetAllStatuses"); DatabaseBootstrapper.Drop(); DataTableConverter dtp = new DataTableConverter(); dtp.DataTableParserSettings.MissingMappingHandling = MissingMappingHandling.Ignore; var results = dtp.ConvertToObjectList <StatusExtraProperty>(dataTable); Assert.Equal(dataTable.Rows.Count, results.Count()); }
public void GetAllStatuses_ReturnsResults_CanBeParsedWithCorrectObjects() { DatabaseBootstrapper.CreateAndPopulate(); DataTable dataTable = QueryRunner.ExecuteStoredProcedure("uspGetAllStatuses"); DatabaseBootstrapper.Drop(); DataTableConverter dtp = new DataTableConverter(); var results = dtp.ConvertToObjectList <StatusPropertyNamesMatch>(dataTable); Assert.True(results.Where(r => r.Id == (int)dataTable.Rows[0]["Id"] && r.Description == dataTable.Rows[0]["Description"].ToString() && r.IsPublic == (bool)dataTable.Rows[0]["IsPublic"]).Count() == 1); }