Conversion of equals expressions

[aronDisi]

I am trying to get some confidence on the SQL emitted by certain predicates. First is case insensitive comparison. What SQL will be emitted if I do "FindAll( x => x.Name.Equals( name, StringComparison.OrdinalIgnoreCase ) )"? The second case is nullable fields, especially nullable value types, comparison. How would "FindAll( x => x.MaybeNull.HasValue && x.MaybeNull.Value == value )" or "FindAll( x => x.MaybeNull.GetValueOrDefault( myDefault ) == value )" be handled?

[phnx47]

Take a look at ExpressionHelper.cs.

Case-insensitive comparison in #400.

[aronDisi]

I think it should be WHERE [Table].[Col] COLLATE SQL_Latin1_General_CP1_CI_AS = @param Aron Rubin Chief Scientist Dynamic Imaging Systems, Inc. Mobile (856) 625-4281<tel:+18566254281> Learn more about mobile inmate tracking with CorreTrak<http://dynamicimaging.com/solutions/mobile-inmate-tracking/>

…

________________________________ From: Serge K ***@***.***> Sent: Sunday, February 2, 2025 9:42:17 PM To: phnx47/dapper-repositories ***@***.***> Cc: Aron Rubin ***@***.***>; Author ***@***.***> Subject: [EXTERNAL] Re: [phnx47/dapper-repositories] Conversion of equals expressions (Discussion #446) CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. Take a look at ExpressionHelper.cs<https://urldefense.com/v3/__https://github.com/phnx47/dapper-repositories/blob/main/src/SqlGenerator/ExpressionHelper.cs__;!!HzYX23eHnp2Wbe4!TARzJC2DAIi6yHeCvLNwNEtpQChJ944NCPlMJ0vZyCjUCYvEEbNmk1q9LCsF8U0dYlzyrorLlRN0N6X2H2jYL-EdvTt0$>. Case-insensitive comparison in #400<https://urldefense.com/v3/__https://github.com/phnx47/dapper-repositories/issues/400__;!!HzYX23eHnp2Wbe4!TARzJC2DAIi6yHeCvLNwNEtpQChJ944NCPlMJ0vZyCjUCYvEEbNmk1q9LCsF8U0dYlzyrorLlRN0N6X2H2jYLyTgOl6j$>. — Reply to this email directly, view it on GitHub<https://urldefense.com/v3/__https://github.com/phnx47/dapper-repositories/discussions/446*discussioncomment-12036140__;Iw!!HzYX23eHnp2Wbe4!TARzJC2DAIi6yHeCvLNwNEtpQChJ944NCPlMJ0vZyCjUCYvEEbNmk1q9LCsF8U0dYlzyrorLlRN0N6X2H2jYLy94wkDT$>, or unsubscribe<https://urldefense.com/v3/__https://github.com/notifications/unsubscribe-auth/BKM6AASHZGWWARIM2L7Z4NL2N3JQTAVCNFSM6AAAAABWKTPJOGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTEMBTGYYTIMA__;!!HzYX23eHnp2Wbe4!TARzJC2DAIi6yHeCvLNwNEtpQChJ944NCPlMJ0vZyCjUCYvEEbNmk1q9LCsF8U0dYlzyrorLlRN0N6X2H2jYL242f-af$>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[phnx47]

Added a simple unit test with a nullable field

dapper-repositories/tests/SqlGenerator.Tests/MsSqlGeneratorTests.cs

Lines 398 to 408 in c7aea28

	[Fact]
	public static void NullableIsNotNull()
	{
	var userSqlGenerator = new SqlGenerator<User>(_sqlConnector, true);
	var tomorrow = DateTime.Now.Date.AddDays(1);
	var sqlQuery = userSqlGenerator.GetSelectAll(u => u.UpdatedAt != null && u.UpdatedAt < tomorrow, null);
	Assert.Equal(
	"SELECT [Users].[Id], [Users].[Name], [Users].[AddressId], [Users].[PhoneId], [Users].[OfficePhoneId], [Users].[Deleted], [Users].[UpdatedAt] FROM [Users] " +
	"WHERE ([Users].[UpdatedAt] IS NOT NULL AND [Users].[UpdatedAt] < @UpdatedAt_p1) AND [Users].[Deleted] IS NULL", sqlQuery.GetSql());
	}