Category: SQL Server

  • Check table configurations in EF Core 3.1

    To check the table configurations for EF Core 3.1, I did the following and it helped identify issues. It iterates all tables in the context and selects one row. If there is an exception, it will catch it and display some related information. It might be helpful to also capture the stack trace.

  • C# Parallel Tasks gives MAJOR Speed Increase

    I just used parallel tasks to decrease the time a process took from over an hour to about 2 minutes.  I was wary of creating so many database contexts, but it paid off in a major way! See the snippet of code below to see how I used the Parallel.ForEach.  .Net created almost 100 threads during…

  • Converting Oracle Comments to SQL Server.

    I downloaded some code a recently that creates an Oracle Database, but I don’t have Oracle, so I converted most of the code to SQL Server.  One of the harder things to convert was the column and table comments.  One of the features of Oracle that Microsoft SQL Server does not have directly is commenting.…