Per-operation collation in Entity Framework Core

How to offload geography operation to SQL Server in Entity Framework Core 1.0

This is how i've done it. Obviously you don't get the features of the DbGeography type, but for simple queries it should suffice.... public async Task<List<PointOfInterest>> Execute(double latitude, double longitude, int radius) { return await this.context.PointsOfInterest.FromSql( "DECLARE @point geography = geogr...

Entity Framework .Net core FindAsync Throw System.OverflowException: Arithmetic operation resulted in an overflow

I fixed it. I used wrong connection string. I have to put the port number of SQL database in the connection string....the wrong one:...Server=serverAddress;Database=dbName;User Id=dbUser;Password=dbPassword; ...the right one:...Server=serverAddres,portNumber;Database=dbName;User Id=dbUser;Password=dbPassword; ...Default MSSQL port number is 1433...

How to create Table per type inheritance in Entity Framework Core 2.0 code first?

TPT is not in EF Core (yet). See ...The feeling from our team is that TPT is generally an anti-pattern and results in significant performance issues later on. While enabling it may make some folks "happier" to start with it ultimately just leads to issues. We are willing to consider it though, so we're leaving this open and will consider i...

CRUD operations on many to many relationship using entity framework core 2.0 code first

You probably have Id of Computer or User which you want to remove from many-to-many relation. You can call:...private DeleteComputerUser(User user, Guid computerId) { var computerUser = _dbContext.ComputerUser.SingleOrDefault(computerUser=> computerUser.UserId == user.GatekeeperUserId && computerUser.ComputerId == computerId); ...

Table per Type in Entity Framework Core 2.0

You would have to change your Model to look like this, note that you can't use inheritance using this approach:...public class Company { public int CompanyId { get; set; } //... } public class Company { public int CompanyId { get; set; } public string Name { get; set; } //... } public class HeadOffice { [ForeignKey(nameof(Compan...

MySQL collation issue with Entity Framework Core

In MySQL "latin1 - default collation" is not useful for inserting Unicode and non-English word(s), You need to use Utf8Mb4 collation (better version of utf8)....On the table you can set the table charset like this...ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;...Here is a post that give details why ...

Error in EF Core: A second operation started on this context before a previous operation completed

DbContext... is not thread safe...I think this ...ForEach... is your problem.... users.ForEach(async user => { //.... LeaveBalance sickLeaveBalance = await this.GetUserLeaveBalance(user.Id,}); // ..... }); ...as you used ...async... keyword so for each user an action will be invoke ...asynchronousl...

Why am I getting duplicate ID columns when using Table Per Hierarchy in Entity Framework Core?

In your model any Base can be added to the ...Accounts... of an Elevated, and so every Base needs and ElevatedId Foreign Key property. Only a Standard can have an Elevated ...Parent.... ...And a Standard can have an Elevated ...Parent... and belong to the ...Accounts... of a ...different... Elevated.

C# awaited entity framework core in memory operation is very slow when performed within loop

In the end I still dont know what awaiting the ef core save method was slower than the sync version. But I was able to determine that the issue was the in memory database. I no longer use it since my tests involve large result sets - i use a real test database..

How to ensure that Entity Framework Core InMemory database is created per test method?

i think they shared the same database instance...You are correct, ...IClassFixture... is a shared object instance across multiple tests....What you can do to reuse the ...ConfigureWebHost... is use the test class' constructor instead. That way, all your tests will run the configuration but will not share object instances. You might also need to ch...