Skip to main content

EF Core Doubts - Learn these things

 EF Core Doubts - Learn these things

-----------------

1. Migration in details?

2. EF Core has a new feature in LINQ-to-Entities where we can include C# or VB.NET functions in the query. This was not possible in EF 6.

3. EF Core creates a clustered index on Primarykey columns and a non-clustered index on ForeignKey columns, by default.

4. Shadow Properties?

5. Conventions are default rules using which Entity Framework builds a model based on your domain (entity) classes.

6. The Student entity class includes a reference navigation property of Grade type. (https://www.entityframeworktutorial.net/efcore/one-to-many-conventions-entity-framework-core.aspx)

7. The Grade entity includes a collection navigation property of type ICollection<student>. (https://www.entityframeworktutorial.net/efcore/one-to-many-conventions-entity-framework-core.aspx)

8. EF 6.x or prior does not support conventions for One-to-One relationship. Unique constraint is supported in Entity Framework Core but not in EF 6 and that's why EF Core includes conventions for one-to-one relationship but not EF 6.x.

9. In EF Core, a one-to-one relationship requires a reference navigation property at both sides.

10. Data annotation attributes are the same in EF 6 and EF Core.

11. Fluent API configurations have higher precedence than data annotation attributes.

12. Many-to-many relationships without an entity class to represent the join table are not yet supported.

 However, you can represent a many-to-many relationship by including an entity class for the join table and mapping two separate one-to-many relationships.

 (https://docs.microsoft.com/en-us/ef/core/modeling/relationships?tabs=fluent-api%2Cfluent-api-simple-key%2Csimple-key)

13. Entity Framework Core introduced a new type of property called "Shadow" property which was not exist in EF 6.x.

14. FromSql Limitations

a. SQL queries must return entities of the same type as DbSet<T> type. e.g. the specified query cannot return the Course entities if FromSql is used after Students. Returning ad-hoc types from FromSql() method is in the backlog.

b. The SQL query must return all the columns of the table. e.g. context.Students.FromSql("Select StudentId, LastName from Students).ToList() will throw an exception.

c. The SQL query cannot include JOIN queries to get related data. Use Include method to load related entities after FromSql() method.


Labels:

Comments

Post a Comment

Popular posts from this blog

All the require docs of job seekers (java docs, testing docs, study materials, genuine consultancy link)

# JUST_FOR  JAVA LOVERS : CORE & ADVANCED JAVA Notes ! Core Java and Advanced Java Notes! . Link 1 :-  https://www.dropbox.com/s/t…/1--%20Core%20Java%28TOC%29.pdf… Link 2 :-  https://www.dropbox.com/s/0ahi8r…/9--%20Advanced%20Java.pdf… _________________________________ 1.  https://drive.google.com/…/0BxJrew1xg5ZLZjdabnVUUkswalk/view 2. https://drive.google.com/…/0BxJrew1xg5ZLVHVSQ0tiU1VmVXM/view 3. https://drive.google.com/…/0BxJrew1xg5ZLdS1JUTAxMWtTcEU/view 4. https://drive.google.com/…/0BxJrew1xg5ZLY1M5bGp2Ym5lZUk/view 5. https://drive.google.com/…/0BxJrew1xg5ZLck13Rndpd1ZlcEU/view 6.  https://drive.google.com/…/0BxJrew1xg5ZLb2xodlhOTEVzLTA/view --------------------- Spring --------------------- https://drive.google.com/…/0BxJrew1xg5ZLQ3VaQnlja3N1Mkk/view https://drive.google.com/…/0BxJrew1xg5ZLTXNVLUdOR0xmTzQ/view https://drive.google.com/…/0BxJrew1xg5ZLWU9PUmVKUUYtMjQ/view ---------------------- Hibernate ---------------------...
Post a Comment
Read more

npm install on windows 7 python2 not found error and node-sass@3.13.1 error #317

Before I write all, I'd like to say that before the update everything worked well; while updating node from version 7.2.1 to version 9.4.0 and npm from version 5.5.1 to version 5.6.0 in Windows 7 (64-bit) using the installer (https://nodejs.org/en/download/) and installing globally gulp-cli version 2.0.0, as far as npm install starts from the JointsWP folder I get the following error: $ npm install npm WARN deprecated babel-preset-es2015@6.24.1: รฐ  Thanks for using Babel: we recommend using babel-preset-env now: please read babeljs.io/env to update! npm WARN deprecated gulp-util@3.0.8: gulp-util is deprecated - replace it, following the guidelines at https://medium.com/gulpjs/gulp-util-ca3b1f9f9ac5 npm WARN deprecated minimatch@2.0.10: Please update to minimatch 3.0.2 or higher to avoid a RegExp DoS issue > uws@0.14.5 install C:\Users\Bob\Dropbox\Development\vhosts\mongoose-project\vanilla\themes\JointsWP\node_modules\uws > node-gyp rebuild > build_log.txt 2>...
1 comment
Read more

Fluent API EntityFramework 6 C#

Brief We will develop simple Database Call (SQL Server) using EntityFramework using the Fluent API. We will have below things for the DB Cal. Student Class StudentMap Class PracticeContext Class DataBaseCall Class Proram Class app.config (In web development, we have web.config) Student Class: namespace DotnetConsole {   public class Student   {     public int ID { get; set; }     public string Name { get; set; }   } } StudentMap Class This class is required since fluent api is creating table from the configuration. public class StudentMap: EntityTypeConfiguration<Student>   {     public StudentMap()     {       this.ToTable("Student");       this.Property(s => s.ID).HasDatabaseGeneratedOption(System.ComponentModel.DataAnnotations.Schema.DatabaseGeneratedOption.Identity);       this.Proper...
Post a Comment
Read more