EF Core

EF Core 5

  • EF Core 5 does not work with .net framework. It works with .net core 3.0 and above

Many to Many Relationships

  • EF core can handle a simple many to many relationship without including a class that represents the associative table. All you need to do is add navigation properties between the two classes that have a many to many relationship.

    • for a more complex many to many relationship, a class will need to be created to represent the associate table. In addition, the OnModelCreating must be updated to define the many to many relationship. Use fluent methods: HasMany, WithMany, and UsingEntity

Bulk Operation

  • it will not work when working with less than 4 insertion/update
    • example of increasing and decreasing batch size


Comments

Post a Comment

Popular posts from this blog

Adding CKEditor 4 to Angular

You can add CKEditor 4 to angular following instruction from here . Add ckeditor using npm: npm install ckeditor4-angular After installing, import CKEditorModule to your application: import { CKEditorModule } from 'ckeditor4-angular'; @NgModule( { imports: [ ... CKEditorModule, ... ], … } ) Use the  CKEditor 4 online builder to quickly customize and generate ckeditor files. Unzip the generated file and copy the ckeditor folder into your projects assets folder.  In index.html, add a script reference to ckeditor: <script src="assets/ckeditor/ckeditor.js"></script> Then in a component, you can use ckeditor like this: <ckeditor data="<p>Hello, world!</p>"></ckeditor>
Read more

Using @CurrentIteration with TFS API

Image
@CurrentIteration is neat macro I use when I created saved queries in TFS. For example, I recently needed to write a query that fetched all current bugs in the sprint: This works great in the TFS web interface. The main reason for me to create this saved query was however was to be able to access it via the TFS API. So I started like this: using ( var workItemTrackingHttpClient = new WorkItemTrackingHttpClient ( new Uri ( " http://mytfs/tfs/Plato " ) , new VssCredentials ( ) ) ) { try { var items = workItemTrackingHttpClient . QueryByIdAsync ( new Guid ( " 25c6e737-d0ce-416f-9f7a-3cb78959334d " ) ) . Result . WorkItems ; } catch ( Exception ex ) { } } This returned the following error: System.AggregateException: One or more errors occurred. ---> Microsoft.VisualStudio.Services.Common.VssServiceException: VS402612: The macro '@CurrentIteration
Read more