Entity Framework Core - Knowledge Base (KB)

Aggregation with GROUP BY using AspNet Core OData and Entity Framework Core

Simple OData aggregation fails on Entity Framework Core (SQL Sever) and Asp.Net Core:...odata/file?$apply=groupby((FileType)) ...Due to inability to translate used GroupBy LINQ expression warning is issued:...Microsoft.EntityFrameworkCore.Query: Warning: ...

InsertOrUpdate throwing error for identity primary column

I was following article for InsertOrUpdate using Entity Framework Core and SQL Server....http://blog.linq2db.com/2015/05/linq-crud-operations.html...So my linq2db query is same as their documentation....using (var db = new DataConnection()) { db.GetTa...

System.TypeLoadException Could not load type 'Microsoft.EntityFrameworkCore.Query.RelationalQueryContextFactory'

I have written basic simple query which was working before when I was using .net core 2.2 (I have used ...linq2db.EntityFrameworkCore...)...projectContext.DocumentAnnotation.ToLinqToDBTable().InsertWithIdentity(() => new DocumentAnnotation { Name = name, ...

Linq2db entity framework update query for dynamic table and column

I want a generic query for all the tables using ...linq2db.EntityFrameworkCore...I have 5 things. 1. TableName 2. ColumnaName 3. ColumnValue 4. Where condition column name 5. Where condition column value....So far what I am trying practically is some...