Question : I’m working with a developer who is struggling to stop the following error: The server will drop the […]
Tag: entity-framework
Is the ADO.NET Entity Framework known for generating poorly performing queries?
Question : This question is inspired by the comment posted to the latest ServerFault blog post: Are you guys still […]
Table with only a single constant value?
Question : I use C# entity framework code first. My knowledge regarding databases is almost nothing. I don’t know if […]
Microsoft SQL Server how can i detach localdb to run on any computer
Question : I am working on a personal project and have implemented a database system using the Entity Framework code […]
Multiple roundtrips vs cross joins
Question : I have a feeling the answer is “it depends on…”, but I’m wondering if there’s a concrete answer. […]
Entity Framework Coupling with Database
Question : I am new to EF and Database Design. I have been studying about using Repository Pattern and Unit […]
Curious Database building Problem (ER Diagram)
Question : I am trying to build an EER Model for a Autostore that has 5 locations and offers a […]
MSSQL Join between big and empty tables
Question : I’ve got an issue with estimated cost and join predicate : SELECT c.Id FROM Table_A a LEFT JOIN […]
Empty result takes longer with all columns included
Question : I’m executing a query every 1 second and most of the time it returns no results (SQL generated […]
Delete Joined to Derived Table Causes Index Scan and Table Spool
Question : Our application uses a popular 3rd-party extension to Entity Framework that allows for valuable things that native Entity […]