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_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_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 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
}
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 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_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_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_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_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);
}
}
