[SQLServer] insert bool value #437

[mvernikUt]

The same issue still exists: #437

Could you please specify if am I doing something wrong, because I just need to have generated SQL?

public class ClientMode
  {
      public Guid Id { get; set; }
      public Guid ClientId { get; set; }
      public string Name { get; set; }
      public string Url { get; set; }
      public string Secret { get; set; }
      public string? Version { get; set; }
      public string? DataCsv { get; set; }
      public bool Enabled { get; set; }
  }

var queryBuilder = new Query("ClientMode").AsInsert(entry);
SqlResult result = _sqlCompiler.Compile(queryBuilder);

INSERT INTO [ClientMode] ([Id], [ClientId], [Name], [Url], [Secret], [Version], [DataCsv], [Enabled]) VALUES ('732ae0ec-6409-445d-9dfe-bc77a1ac85d0', '00000000-0000-0000-0000-000000000000', 'test0004', 'test0004', 'CVhulQgha6TpAcEx4rDrTVxBE0DQ11sV', 'test', 'string', true)

Issue: SQL Server accepts BIT instead of Boolean

[vip32]

this just bit me, still a thing in 2024?