efcore
efcore copied to clipboard
dotnet
EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
Today, the `GetFluentApiCalls` and `GetDataAnnotations` extensions used by the templates automatically filter out configurations that will be handled by conventions. It would be nice if the user could still choose...
Today, the templates add usings for the fluent API calls after the list of calls is retrieved. ```cs var propertyFluentApiCalls = property.GetFluentApiCalls(annotationCodeGenerator) ?.FilterChain(c => !(Options.UseDataAnnotations && c.HasDataAnnotation) && !(c.Method ==...
Having queries and execution times in log is awesome feature, but for some queries it's not that useful and can generate a lot of noise. For example when inserting or...
See [blog post](https://devblogs.microsoft.com/dotnet/announcing-dotnet-7-preview-7/#simplified-ordering-with-system-linq). These new methods aren't useful over entities, but can be useful after the user has projected from the entity to some column and wants to order that....
SQLite 3.37.0 added support for [STRICT tables](https://www.sqlite.org/stricttables.html) which codified a new column type name--`ANY`. We should review the places we use the column type name and make sure we're handling...
```C# context.Customers.ExecuteUpdate(s => s.SetProperty(c => c.Property, c => c.Navigation.Value)); ``` Nav expansion needs to expand `c.Navigation` but it is inside doubly nested lambda hence it doesn't recognize implicitly and requires...
See https://github.com/dotnet/efcore/issues/28205
Jsonpath is a standard language for querying inside JSON documents, supported by [PostgreSQL](https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-SQLJSON-PATH), [SQL Server](https://docs.microsoft.com/en-us/sql/relational-databases/json/json-path-expressions-sql-server?view=sql-server-ver16), and possibly others. We could have a pipeline for translating LINQ operators inside JSON documents...
- [ ] Process join entity types in KeyDiscoveryConvention.ProcessForeignKeyPropertiesChanged, similarly for SqlServerOnDeleteConvention - [ ] Don't use a convention scope in `UsingEntity` - [ ] Consider setting nullability for value...
As discussed offline, we're going to add these, which are identical to FromSqlInterpolated/ExecuteSqlInterpolated. FormattableString is safe from SQL injection attacks, so we generally want to guide users towards doing raw...