bitScry

  • Home
  • About
  • Blog
  • Contact

Entity Framework

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
  • Killing a Process Locking Port on a Mac
  • Mocking Hangfire BackgroundClient Jobs
  • Running Shinobi CCTV on a Raspberry Pi
  • Visual Studio CoreCLR Error
  • Adding Healthchecks to a .NET Core 6 API
Tag Cloud

.NET Core AAD API ASP.NET Core Authentication Authorization Azure Azure Active Directory Azure Function Azure Storage Blob Bootstrap C# Cloud Storage Console Application CSS DataTable Dependency Injection Dictionary Entity Framework Enum Extension Google GZip HTML IP Address JavaScript jQuery JSON List MVC MVC 6 Newtonsoft RestSharp Serilog SQL SSDT Stored Procedure Stream String Table Table Storage Web App Web Application WordPress

Programming

Using OData with Entity Framework

OData is an open protocol for enabling interaction with a datasource in a standardised way via a RESTful API. Theoretically using OData in combination with Entity Framweork should provide a simple way of providing access to SQL (or other) data via API, this is indeed the case but setting things Read more…

By Shinigami, 2 years7 April 2020 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, 2 years2 April 2020 ago
Programming

Converting a Char Character to an Enum in Entity Framework

If you’re using Entity Framework with a legacy database then you may well have single character status flags in some of the columns such as “O” = Operational, “M” = Marketing. Ideally these would be numeric IDs that match to a separate status table which would allow the IDs to Read more…

By Shinigami, 3 years29 July 2019 ago
Programming

Querying Views Without Primary Keys in Entity Framework

Entity Framework is a nice way of accessing databases without having to write any data access code. Because Entity Framework is able to modify data in your database it needs a primary key to be defined in order for it to be able to uniquely identify rows. In my case Read more…

By Shinigami, 3 years4 July 2019 ago
  • Facebook
  • Twitter
  • Instagram
  • Email
Hestia | Developed by ThemeIsle