Dapper/SQLite get new primary after inserting a new record.

#sqlite #dapper #csharp

Took time this morning to update an article on DateOnly and TimeOnly. Had written the article with a beta NuGet package and EF Core 7. Removed beta package and updated to EF Core 8. Also added a Dapper code sample.

An important part of the updates were to leave old code

Thought I would let GitHub Copilot provide assistance today.

Wrote the following code without the casting. When a runtime exception was thrown, I asked Copilot and in this case on both recommendations Copilot was spot on.

#github #github copilot #copilot #csharp #dapper

Visual Studio feature: Create item template

With this feature a developer takes an existing class and create a reusable template.

For instance, a class which contains base code to read settings from appsettings.json

learn.microsoft.com/en-us/visualst…

#visualstudio

Just received buy in from a client to start work on one of their web application to move forward to make the application WCAG AA conformant.

Its a know fact that web applications that are AA compliant provide a better user experience for visitors and customers. Sell a product

Visual Studio 2022, add new project to a solution alternative.

With a solution open, paste a new project in from Windows Explorer into the solution folder.

Back in VS Solution Explorer, select folder view in solution explorer than back to solution view and the project just

Question of the day (T-SQL)
There are two choices, CASE or IIF ?

This morning working on upgrading a solution for working with dates from a SQL-Server database for teaching tomorrow.

In the screenshot below, Calendar table is awesome.

GitHub repository link to follow once finished.

#csharp #tsql #sqlserver #net8 #visualstudio

The weather is great so I'm heading out for a drive 🏎️

Customize menus and toolbars in Visual Studio
I like to add external tools to the menu bar.

One enhancement would be to have external tool items to have names for proper identifying external tool items.

learn.microsoft.com/en-us/visualst…

Visual Studio request
Individual window zoom settings
Vote if you like to see this.

developercommunity.visualstudio.com/t/Individual-w…

The yield operator allows the creation of items as it is demanded. Do you find a need to use yield?

Simple example which does not really do anything special but we could do some processing before the return statement based on the type.

Sometimes even with multiple monitors, vertical window groups make viewing code easy and for single monitors better than tabbing.

For more on tabs/windows
youtube.com/watch?v=NBfNny…

#vs2022 #visualstudio

Sqlite in-memory database using Dapper.

github.com/karenpayneoreg…