public void Compare_rows_containing_decimal_with_numeric()
{
using (var ctx = new ComparisonTestContext())
{
var expectedSql =
@"SELECT
[Extent1].[Id] AS [Id]
FROM [dbo].[NumericEntities] AS [Extent1]
WHERE ([Extent1].[Id] = [Extent1].[Id]) AND ([Extent1].[DefaultDecimal] = [Extent1].[DefaultNumeric])";
var query = ctx.Numerics.Where(s => new { first = s.Id, second = s.DefaultDecimal } == new { first = s.Id, second = s.DefaultNumeric }).Select(c => c.Id);
QueryTestHelpers.VerifyQuery(query, expectedSql);
}
}
public void Compare_rows_containing_nullable_string_with_nonnullable_string()
{
using (var ctx = new ComparisonTestContext())
{
var expectedSql =
@"SELECT
[Extent1].[Id] AS [Id]
FROM [dbo].[StringEntities] AS [Extent1]
WHERE ([Extent1].[Id] = [Extent1].[Id]) AND ([Extent1].[NonUnicodeFixedLength25] = [Extent1].[NullableNonUnicodeVariableLength25])";
var query = ctx.Strings.Where(s => new { first = s.Id, second = s.NonUnicodeFixedLength25 } == new { first = s.Id, second = s.NullableNonUnicodeVariableLength25 }).Select(c => c.Id);
QueryTestHelpers.VerifyQuery(query, expectedSql);
}
}
public void Compare_rows_containing_datetime2_with_different_precision()
{
using (var ctx = new ComparisonTestContext())
{
var expectedSql =
@"SELECT
[Extent1].[Id] AS [Id]
FROM [dbo].[DateTimeEntities] AS [Extent1]
WHERE ([Extent1].[Id] = [Extent1].[Id]) AND ([Extent1].[DefaultDateTime2] = [Extent1].[DateTime25])";
var query = ctx.DateTimes.Where(s => new { first = s.Id, second = s.DefaultDateTime2 } == new { first = s.Id, second = s.DateTime25 }).Select(c => c.Id);
QueryTestHelpers.VerifyQuery(query, expectedSql);
}
}
public void Compare_rows_containing_nullable_string_with_nonnullable_string()
{
using (var ctx = new ComparisonTestContext())
{
var expectedSql =
@"SELECT
[Extent1].[Id] AS [Id]
FROM [dbo].[StringEntities] AS [Extent1]
WHERE ([Extent1].[Id] = [Extent1].[Id]) AND ([Extent1].[NonUnicodeFixedLength25] = [Extent1].[NullableNonUnicodeVariableLength25])";
var query = ctx.Strings.Where(s => new { first = s.Id, second = s.NonUnicodeFixedLength25 } == new { first = s.Id, second = s.NullableNonUnicodeVariableLength25 }).Select(c => c.Id);
QueryTestHelpers.VerifyQuery(query, expectedSql);
}
}
public void Compare_rows_containing_decimal_with_numeric()
{
using (var ctx = new ComparisonTestContext())
{
var expectedSql =
@"SELECT
[Extent1].[Id] AS [Id]
FROM [dbo].[NumericEntities] AS [Extent1]
WHERE ([Extent1].[Id] = [Extent1].[Id]) AND ([Extent1].[DefaultDecimal] = [Extent1].[DefaultNumeric])";
var query = ctx.Numerics.Where(s => new { first = s.Id, second = s.DefaultDecimal } == new { first = s.Id, second = s.DefaultNumeric }).Select(c => c.Id);
QueryTestHelpers.VerifyQuery(query, expectedSql);
}
}
public void Compare_rows_containing_datetime2_with_different_precision()
{
using (var ctx = new ComparisonTestContext())
{
var expectedSql =
@"SELECT
[Extent1].[Id] AS [Id]
FROM [dbo].[DateTimeEntities] AS [Extent1]
WHERE ([Extent1].[Id] = [Extent1].[Id]) AND ([Extent1].[DefaultDateTime2] = [Extent1].[DateTime25])";
var query = ctx.DateTimes.Where(s => new { first = s.Id, second = s.DefaultDateTime2 } == new { first = s.Id, second = s.DateTime25 }).Select(c => c.Id);
QueryTestHelpers.VerifyQuery(query, expectedSql);
}
}
