Does Entity Framework Core support MariaDB?

Whats the best solution to Entity Framework cores lack of moderate LINQ query support?

So basically I have a table containing a set of data. This data is then joined onto an organisation table to which multiple users can be apart of. Im then trying to get all files in the table where the user executing the query, has permission to access the organisation. To do this I'm using a where clause that checks the users permissions from the ...

Always Encrypted in Entity Framework Core Support

Do not role your own implementation. What we ended up doing was creating a separate Windows Classic Desktop class library project in our solution that handled the data layer for the table with encrypted columns. We used Dapper for the ORM in that project and it supported the encrypted columns. It really limited some things we could do since the...

Entity Framework Core support for SQL Spatial Data Types - DBGeography?

I want to make a web application using ASP.NET Core Razor Pages that has some geographic data in SQL Server. Visual Studio gives an error that it doesn't support the Geography data type when creating the EF model using EF Core from an existing SQL DB. Is there a way to use SQL Spatial Data Types like Geography in an ASP.NET Core project using Ent...

What SQL Server 2017 features are not supported in Entity Framework Core code first?

EF Core is only ORM....1) You should be ready to create all DB objects except tables manually. What I create manually: constrates (defaults as well as conditions). Since this is code first - there is no need in SP, functions and so on. If you use ORM - DB is only storage. Of course practice is important. For me default constraints adds comfort on t...

Does Entity Framework Core support Union?

I am trying to query multiple tables in EF Core using union as below, but it does not allow. Please find the query and also attached the image on the error hint that .net core frame work provides.... var query = _context.Brand.Select(x => new { BrandID = x.Brandid }) .Union(_context.Factory.Select(x => new { Fa =...

Entity Framework Core SQLite Connection String Keyword not supported: version

There is a thread in ...Github... regarding the issue. ...Microsoft.Data.Sqlite... only supports three keywords: ...Cache... - ...Private or Shared...Data Source... - ...The database file. Can be a URI filename....Mode... - ...ReadWriteCreate, ReadWrite, ReadOnly, or Memory....No other keywords are supported for this namespace, however if you use t...

Does Entity Framework Core support database password rotation

You should be able to add the ...DbContext... into DI and pass a delegate which creates the instance essentially taking control of the static nature of the connection string and work out the correct one at runtime....services.AddScoped<YourDbContext>(svc => { var connString = ... logic to get the conn string with the right password fr...

Entity Framework Core - Has Conversion - Support Null Values

I have an EF model with a notification emails property. The notification emails are saved in the database as string separated by ';'. I added a conversion to retrieve the data as a ICollection in the model. This is working well except one thing: when the string is null the collection is also null, and I want to convert it to an empty collection ins...

System.Not Supported exception for mocking ExecuteSQLCommand Moq Entity Framework Core

I am trying to write a unit test for a method in my database layer. I am getting error at ...context.Setup... for ...ExecuteSqlCommand...:...System.NotSupportedException: 'Unsupported expression: ... => .......ExecuteSqlCommand((RawSqlString)It.IsAny<string>(), It.IsAny<object[]>())... Extension methods (here: RelationalDatabaseFacadeExtensions.Ex...

Why Entity Framework core does not support raw sql query?

I was using entity framework 6 in my asp.net application and using raw queries like following:...string studentName = ctx.Database.SqlQuery<string>( "Select studentname from Student where studentid=1").FirstOrDefault(); ...Now I am moving my application to asp.net core, but I could not found raw sql query without using DbSet type. ...var s...