If you need a quick and dirty solution to validate string lengths in a .NET model against exact-match columns in SQL Server, you can use this script. This will find all of the varchar and nvarchar columns for a table, and build code to ensure the model doesn’t exceed the max length for any of […]
For a bulk insert from .NET to SQL Server, you’ve got a few options, but the DataTable is probably the easiest:
Here’s what I’ll use as the starting point for any new console application that I build. It includes simple logging to the console and to a file, dependency injection, and strongly typed configuration, including user secrets that don’t go to source control. Main.cs Program.cs appsettings.json secrets.json (in your user directory, not in the project directory) […]
To add bytes to the end of a binary file, this is the basic code needed: If you’re potentially bringing in a lot of data, make sure you use a stream for the incoming data and write a little at a time. For a small amount of data, you can use a ReadOnlySpan<byte> instead of […]
Here are the basic ways of writing bytes to a file. Both of these will create a new file, or overwrite if the file alread exists. Both of these are useful depending on your situation.
Here are the basic ways of appending text to an existing file. Each of these will create a new file if the file does not already exist. Each are useful in different situations. All three of these have an equivalent Async version as well.
Here are the basic ways of writing text to a file. Each of these will create a new file, or overwrite if the file already exists. Each are useful in different situations. All three of these have an equivalent Async version as well.
Don’t ask me to explain it, but setting ARITHABORT in SQL Server is sometimes necessary for performance reasons. In simple ADO.NET, you can use this pattern: