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
}
