Lab Sql

PROBLEM: I am trying to create a EF6 model using the database first approach. Simply speaking, I ha… Read more Ef6 Does Not Generate Foreign Key Association From Database

Here you can see my reduced entity structure which I would like to store in my Sqlite database. I&#… Read more Ef Code First, Entities With Multiple Relations

Profiling some queries in our product, I found that use of Entity Framework 6 parameters impact on … Read more Entity Framework 6 - Parameter Query 11x Slower Than Inline Parameters Query. Why?

We fight the issue in production when once in a while our Azure SQL database performance significan… Read more Active Azure Sql Connections Are Over The Connection Pool Limit

Suppose i have a one parameter stored procedure : procedure dbo.MyStoredProc @param VARCHAR(50) as … Read more Sql Stored Proc And Entity Framework 6

I'm working on an Entity Framework Code First project where, previously, I had a class with a f… Read more Switching To Artificial Key With Different Type In Entity Framework Migrations

Question: How do I convert a LINQ query the performs a LEFT OUTER JOIN on a sub-select that INNER J… Read more Entity Framework Core 5.0 How To Convert Linq For Many-to-many Join To Use Intersection Table For Asp.net Membership

That's my basic (Database First) diagram on SQL Server: When I Update Model from Database usin… Read more How Can I Get A List Of Linked 1-n Elements?