We’re currently working on a .NET backend API project that retrieves data from a MySQL database and returns it to a frontend React app. As this is a migration project we’re working with a pre-existing MySQL database which given it’s currently supporting a live application we’re loath to make structural Read more…
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…
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…
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…
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…