bitScry

  • Home
  • Blog
  • Contact
  • GitHub

C#

About This Site

This is a blog to help me remember some of the coding challenges I’ve faced and hopefully help others out if they’re suffering the same problems.

Recent Posts
  • Inspecting Data in SQL Tables 4th December 2020
  • RestSharp Response Character Encoding 24th September 2020
  • RestSharp AWS S3 Authentication 18th September 2020
  • Grouping Azure Table Storage Entities 17th September 2020
  • Best Practices for Using Azure SDK with ASP.NET Core 9th September 2020
Tag Cloud
.NET .NET Core API appsettings.json ASP.NET Core Authentication Authorization Azure Azure Active Directory Azure AD Azure Function Azure Storage Blob Bootstrap C# Console Application CSS CSV DataTable Dependency Injection Dictionary Enum Extension GZip HTML Image JavaScript jQuery JSON List Middleware MVC MVC 6 Random Serilog SFTP SQL Stored Procedure Stream String Table Table Storage Tag Helper Web Application WordPress
Reading List
  • Build a Wi-Fi Scanner
  • IoT Weather Station
  • User accounts made easy with Azure
  • Install macOS High Sierra in VirtualBox
Programming

Escaping the @ Symbol in an MVC View

I’ve been working with OData recently and one thing that briefly stumped me was that the property names begin with @ and in an MVC view the @ symbol is used to indicate C# code so when I tried to reference a property in JavaScript the page then thought I Read more…

By Shinigami, 11 months11 months ago
Programming

Creating C# Classes from SQL Tables

If you want to use Entity Framework to access pre-existing SQL tables (the database first approach) then providing they’re all keyed up correctly it’s possible to generate all the required classes and the DB context for them with just a few commands. First you need to install the following 3 Read more…

By Shinigami, 11 months11 months ago
Programming

Publishing Additional Files in Visual Studio Code

When creating a console application I normally mimic ASP.NET core apps and keep my configuration settings in an appsettings.json file. When publishing the application in Visual Studio the appsettings.json file needs to have it’s properties updated to ensure it’s copied to the publish folder like so. Doing this updates the Read more…

By Shinigami, 12 months12 months ago
Programming

Dependency Injection in Azure Functions v3

In the v3 version of Azure Functions DI is better supported and there’s now some offical documentation demonstrating how it’s done. It’s pretty similar to how it was done previously, below is updated code from my previous v2 example. Startup.cs The IFunctionsHostBuilder instance is created by the Azure functions host Read more…

By Shinigami, 1 year8 months ago
Programming

IAsyncEnumerable Disambiguation

I’ve been using IAsyncEnumerable recently for the streaming of SQL query rows and of deserialized objects from API calls and while it seems to work like a charm it does seem to have a few configuration issues. Firstly, on creating a new .NET Core project in Visual Studio 2019 (v16.3.5) Read more…

By Shinigami, 1 year1 year ago
Programming

Streaming API Data into SQL

As part of a recent project I’ve had to download a gzipped file of product details from a client endpoint and to load these products into a local SQL database. Although this is easy enough to do in discrete synchronous steps as below what I really wanted to do was Read more…

By Shinigami, 1 year1 year ago
Programming

Azure Storage Authentication Using Managed Service Identities

I usually access Azure Blob Storage by using a SAS key but I am trying to move everything over to KeyVault and Managed Service Identities (MSI) to improve security and secret management. During this process I kept on receiving the following error. I could connect to the container using my Read more…

By Shinigami, 1 year1 year ago
Programming

Creating a Client for Accessing an API in .NET Core

While there seems to be plenty of resources and guides out there to help users create an API there seems to be much less guidance on how to create a client for accessing an API. I’m fine with calling an API using HttpClient or through a library such as RestSharp Read more…

By Shinigami, 1 year1 year ago
Programming

Passing NULL Values to a SQL Stored Procedure from .NET Core

I’ve previously posted about how to cope with nullable values retrieved from a SqlDataReader but it’s also necessary to account for nulls when passing values through to a SQL operation such as a stored procedure. sp__set_completed.sql If you want you’re stored procedure to accept nulls then you first need to Read more…

By Shinigami, 1 year1 year ago
Programming

Creating Random Files in C#

I maintain a library called PGPCore for using PGP encryption in C#, in order to test how this performs when processing large files I needed to create a large file full of random data to check it was encrypting/decrypting as expected. After a bit of searching the answers to this Read more…

By Shinigami, 1 year1 year ago

Posts navigation

Previous 1 2 3 … 6 Next
Hestia | Developed by ThemeIsle