Loving the new auth improvements in .Net 8

#dotnet #identity #entityframework #webapi

https://youtube.com/watch?v=sZnu-TyaGNk&si=Bu60Q7d09ubz1mXo

I'm working with Entity Framework today, and I also received this pamphlet in the mail, and you can't tell me this is a coincidence. #entityframework #dotnet

#dotnet #entityframework
🇺🇸
Has anybody got problems to build a .NET project with lots of migrations ?
After a few years of dev, we have ~1800 files in a folder, and the build server doesn't build (no response, then timeout)

When we remove the folder, it builds (but we can't deploy)

I have searched, but don't find anything about this particular problem (although I have seen people asking how to empty migration history)

#dotnet #entityframework
:us:
Has anybody got problems to build a .NET project with lots of migrations ?
After a few years of dev, we have ~1800 files in a folder, and the build server doesn't build (no response, then timeout)

When we remove the folder, it builds (but we can't deploy)

I have searched, but don't find anything about this particular problem (although I have seen people asking how to empty migration history)

#dotnet #entityframework
🇫🇷
Est-ce que quelqu'un a déjà eu des soucis pour compiler des projets .NET avec un trop grand nombre de migrations ?
Après quelques années de dev, on a un dossier avec ~1800 fichiers, et le serveur de build n'arrive plus à compiler (il arrête de répondre, puis timeout)

En supprimant le dossier ça compile (mais on peut pas déployer)

J'ai beau chercher, je trouve personne qui parle de ce soucis particulier (même si j'ai vu des gens demandant comment vider l'historique)

Wishing Java had a non-reflection way to dynamically generate instances of classes.

(I want to generate objects out of lists of components according to some interface for an entity component framework, for context)

Gonna have to investigate some ORMs or something to see how best to do that sort of thing

Or just get off my ass and move to another language

#java #entityframework #programming #gamedev

Anyone have a favorite .NET 6 EF console app template in a Github repo?

Or are you gonna make me make one?

#dotnet #github #entityframework

#EFCore 8 Preview 2: Lite and familiar - #dotNET Blog
#EntityFramework #SQL https://devblogs.microsoft.com/dotnet/announcing-ef8-preview-2/

Entity Framework Core 8, scheduled to be released in Nov 2023, brings new features & improvements to features already introduced in EF7.

Get a look at what’s new in #EF8: http://bit.ly/3F8Hy2s

#dotnet #EntityFramework #EFCore #EF7 #InfoQ

𝗘𝗙 7 allows mapping properties to the different column names.

For instance, with a 𝗧𝗮𝗯𝗹𝗲-𝗽𝗲𝗿-𝘁𝘆𝗽𝗲 inheritance mapping strategy, the primary keys in the tables may have different names.

𝗘𝗙 allows the mapping to be configured using a nested table builder.

#dotnet #entityframework #devcommunity

𝗘𝗙 7 introduces entity splitting.

It maps a single entity type to multiple tables.

The example below shows how a single 𝗣𝗲𝗿𝘀𝗼𝗻 entity maps to three separate tables - 𝗣𝗲𝗼𝗽𝗹𝗲, 𝗣𝗵𝗼𝗻𝗲𝗡𝘂𝗺𝗯𝗲𝗿𝘀, and 𝗔𝗱𝗱𝗿𝗲𝘀𝘀𝗲𝘀.

#dotnet #entityframework #devcommunity

𝗘𝗙 7 supports many-to-many relationships where one side does not have a navigation property.

In the example below, a 𝗖𝗹𝗮𝘀𝘀 entity does not have a navigation property to a 𝗦𝘁𝘂𝗱𝗲𝗻𝘁 entity.

However, you can still configure a many-to-many relationship between entities.

#dotnet #devcommunity #entityframework

𝗘𝗙 7 introduces a 𝗗𝗲𝗹𝗲𝘁𝗲𝗕𝗲𝗵𝗮𝘃𝗶𝗼𝗿 attribute.

It indicates how a delete operation is applied to a dependent entity in a relationship when it is deleted.

The example below shows disabling the default cascade deletes for the required relationship.

All options for the DeleteBehavior enum you can find by the link.

https://learn.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.deletebehavior?view=efcore-7.0#fields

#dotnet #entityframework #devcommunity

Well, if #dotNET on #macOS is your thing like it is for me, you should also fire up a terminal and type 'sudo dotnet workload update' ...

https://devblogs.microsoft.com/dotnet/february-2023-updates/

#update #security #ASPNETCore #runtime #EFCore #EntityFramework

Well, if #dotNET on #macOS is your thing like it is for me, you should also fire up a terminal and type 'sudo dotnet workload update' ...

.NET February 2023 Updates – .NET 7.0.3, .NET 6.0.14

#update #security #ASPNETCore #runtime #EFCore #EntityFramework

I’m learning about writing unit tests. It feels like the elephant in the room I’ve been ignoring. It feels like there is a lot of leg work, especially for testing my db code but I’m hoping that as the app progresses and I write more tests they’ll feel more useful. Do you write and git commit your tests with your code changes or do you write your tests separately and treat them as separate commits? #git #UnitTesting #xunit #entityframework

Got caught out with a really subtle behaviour with #EntityFramework around the ToDictionaryAsync API.

I expected what I defined as the key was projected in the query so when I had a relationship through a navigation property in the key, I expected it to work without an issue.

Unfortunately ToDictionaryAsync takes Func, not Expression<Func> so it is evaluated client side. Without specifying an Include statement on the navigation property, I got a null-reference exception.

Holy macaroni, Batman!

EF just generated a query in which a inner join resulted in a sub query of 164 columns, just because two tables are using the same key. The query only needs one column of a single table.

And as a bonus: A variation of that query that results in a `UNION ALL` only results in a single column being selected (as I suspected).

I’m not really sure what, why or how is the cause of the behavior. 😳

#EntityFramework #EfCore #dotnet

RT @ArthurVickers@twitter.com

#EFCore 8 News and Progress: https://aka.ms/ef-news

Raw SQL queries for unmapped types
- Parameterized SQL from interpolation syntax
- Uses C# parameterized constructor
- SQL can be further composed with LINQ

Merged for EF Core 8 Preview 1!

#Dotnet #EntityFramework

Help needed with a domain-driven design aggregate root that creates a child entity.

I'm using Entity Framework 7 for the underlying infrastructure.

https://stackoverflow.com/q/75107802/2663033

Thanks in advance.

#dotnet #csharp #entityframework #domaindrivendesign