public void generates_correct_query_using_forward_referencing_foreign_key_attribute() { try { using (var connection = new SqlConnection()) { var results = connection.AutoQuery <LocationDto>( new [] { typeof(FullAddressDto), typeof(CountyDto), typeof(PostCodeDetailsDto), typeof(PostcodeDto), typeof(PostalDistrictNameDto), typeof(OpportunityDto), typeof(FullAddressDto), typeof(CountyDto), typeof(PostCodeDetailsDto), typeof(PostalDistrictNameDto), typeof(PostcodeDto), typeof(ShippingAddressDto), typeof(CountyDto), typeof(PostCodeDetailsDto), typeof(PostalDistrictNameDto), typeof(PostcodeDto), }, new { LocationGuid = Guid.Empty }); } } catch (InvalidOperationException ioe) { CheckException(ioe); } }
public void generates_correct_query_for_complex_merchant_dto() { try { using (var connection = new SqlConnection()) { var results = connection.AutoQuery <MerchantMasterDto>( new[] { typeof(PhoneNumberDto), typeof(CountryDto), typeof(FaxNumberDto), typeof(CountryDto), typeof(ContactMasterDto), typeof(EmailAddressMasterDto), typeof(PhoneNumberDto), typeof(CountryDto), typeof(MobilePhoneNumberDto), typeof(CountryDto), typeof(SalutationDto), typeof(MerchantDetailsDto), typeof(TerminalModelDto), typeof(AddressDto), typeof(CountyDto), typeof(PostCodeDetailsDto), typeof(PostalDistrictNameDto) }, new { MerchantGuid = Guid.Empty }).FirstOrDefault(); } } catch (InvalidOperationException ioe) { CheckException(ioe); } }
public void generates_correct_query_for_complex_application_dto() { try { using (var connection = new SqlConnection()) { var results = connection.AutoQuery <APPLICATION_MST>( new[] { typeof(LEGAL_INFO_MST), typeof(SALES_CHANNEL_LNK), typeof(LOCATION_MST), typeof(BUSINESS_LEGAL_INFO_LNK), typeof(SHAREHOLDER_MST), typeof(PRINCIPAL_MST), typeof(MERCHANT_MST) }, new { ApplicationGuid = Guid.Empty }).FirstOrDefault(); } } catch (InvalidOperationException ioe) { CheckException(ioe); } }
public void querying_class_referencing_subclass_retrieves_children() { try { using (var connection = new SqlConnection()) { var results = connection.AutoQuery <C, B>(new { CKey = 1 }); } } catch (InvalidOperationException ioe) { CheckException(ioe); } }
public void generates_join_using_specified_column_for_many_to_one_with_foreign_key_target_column() { try { using (var connection = new SqlConnection()) { var results = connection.AutoQuery <SimpleUserWithSipDao, SipAccountMstDao>( new { UserKey = 1 }).FirstOrDefault(); } } catch (InvalidOperationException ioe) { CheckException(ioe); } }
public void generates_correct_query_for_many_to_many_relationship() { try { using (var connection = new SqlConnection()) { var results = connection.AutoQuery <UserWithDepartmentsDto, SimpleDepartmentDto>( new { UserKey = 1 }); } } catch (InvalidOperationException ioe) { CheckException(ioe); } }
public void Generates_correct_query_for_count() { try { using (var connection = new SqlConnection()) { connection .AutoQuery <PhoneNumberDto, CountryDto, CurrencyCodeDto>(new { PhoneNumberKey = 1 }, 1); } } catch (InvalidOperationException ioe) { CheckException(ioe); } }
public void generates_correct_query_with_custom_where_condition() { try { using (var connection = new SqlConnection()) { var results = connection.AutoQuery <PhoneNumberDto, CountryDto>( new[] { "n", "c" }, "[c].[TelephoneCountryCode] = @CountryCode AND [n].[PhoneNumber] = @Number", new { CountryCode = "44", Number = "7779123456" }); } } catch (InvalidOperationException ioe) { CheckException(ioe); } }
public void autoquery_with_custom_where_mapping_to_single_type_uses_supplied_alias_and_where_condition() { try { using (var connection = new SqlConnection()) { connection .AutoQuery <ProSupportRule>(new [] { "r" }, "r.[IsForFirstData] = @isForFirstData", new { isForFirstData = false, isForGlobalPayments = false, isForValitor = false }); } } catch (InvalidOperationException ioe) { CheckException(ioe); } }
public void generates_correct_query_for_complex_types() { //var logger = //SimpleSaveExtensions.Logger = // TODO try { using (var connection = new SqlConnection()) { connection .AutoQuery <PhoneNumberDto, CountryDto, CurrencyCodeDto>(new { PhoneNumberKey = 1 }); } } catch (InvalidOperationException ioe) { CheckException(ioe); } // TODO: check the script }