Image by @claybanks
I am working on migrating the .NET Framework application to the .NET6. Since the application was initially written in the .NET Framework 2.0 thus it contains the legacy approaches to get the data from the database. We were using the old version of Microsoft Enterprise Library Data Access package to get the data from the database which is not compatible with the .NET Standard 2.0. So I decided to generate the code for stored procedures using the Dapper and Handlebars templates.
I faced two problems:
- SQL Server system tables does not know about stored procedure parameter nullability
- When you are using conditional logic inside the stored procedure, sql server does not give you correct count of the result sets.