I am using JetEntityFrameworkProvider provider for my EF6.4 for .NET Framework v4.7.2. I recently come across this update query with subquery that fails silently. It produces This fails: This also fails: But this succeeds: Log Both statements generate the same SQL. Neither one produces an error. The failing statements still produce valid SQL, which I […]
Tag: EF6
Custom Property Names in Audit.NET: Handling JSON Serialization in Entity Changes
Recently, I was tasked with building an audit trail log for a legacy WinForms VB.NET project that uses Entity Framework v6.4 on .NET 4.5. Rather than reinventing the wheel, I opted for an open-source library like Audit.NET v20.2.4. The default settings are quite nice, as they list all changes by column name and map the […]
How to Fix JetEntityFrameworkProvider Registration Error in EF6 Projects
Are you trying to install JetEntityFrameworkProvider for your WinForms project and encountered the following error? Ensure the provider factory is registered in the app.config or web.config files for all projects that use EF6 in your solution. If your solution consists of just one project, adding the following snippet to your project’s config file should resolve […]
Jet Entity Framework Provider – in Code Setup
You have been tasked to implement Jet database provider in EF6 to support older database types like MS Access and you want to do this in code for VB.NET? This achieves the same effect as configuring your app.config but adds flexibility of choosing provider based other conditions. In my case, I have to choose and […]