Reverse Engineering MS SQL DB - Bit to bool

[Paul-VSA]

When reverse engineering a table with a non-nullable bit field, such as "IsEnabled", the model generated contains a nullable Boolean field. This obviously does not align well when trying to map the entity model to a DTO, requiring an explicit conversion from bool? to bool.

[ErikEJ]

Which EF Core version - if 6 or 7, use the advanced option to remove the bad default value and make it non-nullable

see https://github.com/ErikEJ/EFCorePowerTools/wiki/Reverse-Engineering#code-generation

duplicate of #160

[Paul-VSA]

Hi Erik, Thank you for your prompt response. Yes, Applying the advanced option seemingly did the trick. Should I mention this in the comments section following my logged issue? The App is on .NET 6. The EF is 7.014. EF PowerTools is 2.5.1718 ***@***.*** Paul Mitchell Visual Software Architects Software Design, Development, & Technical Engineer É Tel: +27 82 957 1205 É Tel: +27 861 VSARAM (872726) ? ***@***.******@***.***> ý www.visualsoftware.co.za<blocked::http://www.visualsoftware.co.za/> [VSARAMpage LOGO&AD] Legal Disclaimer : This information is intended for the person or entity to which it is addressed and may contain private, confidential, proprietary and/or privileged material and may be subject to confidentiality agreements. Any review, retransmission, dissemination, or any other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please contact the sender and delete the material from all storage media. The corporation is neither liable for proper, complete transmission of the information contained in this communication, any delay in its receipt or that the mail is virus free. From: Erik Ejlskov Jensen ***@***.***> Sent: Wednesday, 10 January 2024 15:10 To: ErikEJ/EFCorePowerTools ***@***.***> Cc: PAUL MITCHELL ***@***.***>; Author ***@***.***> Subject: Re: [ErikEJ/EFCorePowerTools] Reverse Engineering MS SQL DB - Bit to bool (Issue #2079) Which EF Core version - if 6 or 7, use the advanced option to remove the bad default value and make it non-nullable see https://github.com/ErikEJ/EFCorePowerTools/wiki/Reverse-Engineering#code-generation duplicate of #160<#160> — Reply to this email directly, view it on GitHub<#2079 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BFHWTXR5L3TAP3HHZGTG6GLYN2HMLAVCNFSM6AAAAABBUXL73OVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQOBUHAZDGOBUHE>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>

[ErikEJ]

Your email reply is already here!