How to use AbpSession?

Using repository pattern to eager load entities using ThenIclude

You can change it to something like this:...public virtual TEntity GetById<TEntity>(int id, Func<IQueryable<TEntity>, IQueryable<TEntity>> func) { DbSet<TEntity> result = this.Set<TEntity>(); IQueryable<TEntity> resultWithEagerLoading = func(result); return resultWithEagerLoading.FirstOrDefault(e => e.Id == id); } ... And you can use...

Include all navigation properties using Reflection in generic repository using EF Core

Working with metadata in EF Core is much easier than in previous EF versions. The ...DbContext... class provides ...Model... property which provides access to...The metadata about the shape of entities, the relationships between them, and how they map to the database....The code which does what you ask could be like this:...public virtual IQueryabl...

Disable conversion between VARCHAR and NVARCHAR when using Entity Framework over an existing SQL server database

The default data type for ...string... columns is ...nvarchar(MAX)..., you don't have the need to set data type in your columns for changing to ...NVARCHAR(MAX).... Ef has default conventions that Specify it. ...here... is explained for knowing conventions....if you want config generally convention for your models, you can do this:...public class D...

Entity Framework core 2.1 Using AsNoTracking with multiple Async gives InvalidOperationException: The connection was not closed

Had exactly the same problem, after some research I found the same answer as what @CamiloTerevinto said....EF Core does not support multiple parallel operations being run on the same context instance. You should always wait for an operation to complete before beginning the next operation. This is typically done by using the await keyword on each as...

Referencing ApplicationUser in the Infrastructure library from an entity in the ApplicationCore library using Clean Architecture

In Clean Architecture:...Application Core Types...• Entities (business model classes that are persisted) and Aggregates...• Interfaces...• Services...• DTOs...• Specifications...• Exceptions...Infrastructure Types...• EF Core types (DbContext, Migrations)...• Data access implementation types (Repositories)...• Infrastructure-speci...

How do I restrict the number of columns used in an INSERT when using EntityFramework?

If there are operations that would insert entities that only provide a subset of columns (non-null-able for example) then you can consider using a bounded context with an entity declaration for just those applicable columns. The bounded context is a smaller, single-purpose context for reading and writing data since a single EF context does not supp...

How to increase insert speed using Bulk insert using AddRange and then SaveChanges in Entity Framework

It doesn't matter if you use Add in a foreach or AddRange, problem lies in SaveChanges method, as it stores changes in observed entities one by one I think. There are libraries out there that allows for real bulk insert of entities using under the hood mechanism of ...SqlBulkCopy...Link to EF Core library: ...EFCore.BulkExtensions...EDIT: For EF6 I...

Getting space used by tables using Entity Framework Core

You could use ...QueryTypes... and ...Raw SQL Queries... together....First, create a class to represent your results and to encapsulate the SQL query. You can organize the following code however you like, but this should get the idea across.... public class DatabaseTableSize { public class View { public string Ta...

Relational-specific methods can only be used when the context is using a relational database provider?

I think the exception thrown is very confusing. I had to look into the source code for ...RelationalDatabaseFacadeExtensions.GetRelationalService... via which I can see somehow the ...TService... is not loaded. That service type may be contained in some dll (the most possible one is ...Microsoft.EntityFrameworkCore.Relational.dll..., if that dll is...

Using EF Core 2.2 to decrypt a string using SQL Server DECRYPTBYKEY

So as I hinted in the comment, it is indeed possible to hack into EFCore's pipeline and make it do custom SQL functions. Here's a ...functional console app... that does it....I will state upfront..., I experimented on a database (see SQL script within my repo link) with ...DECRYPTBYPASSPHRASE... function as I didn't have a key. I also only have ...