How to create Table per type inheritance in Entity Framework Core 2.0 code first? -


following code generates single table "certificateevent".

how achieve tpt inheritance in ef core 2.0?

public abstract class certificateevent {    public int certificateeventid { get; set; } }  public class assignment : certificateevent {...} public class assessment : certificateevent {...}  public class mydbcontext : dbcontext {     public mydbcontext(dbcontextoptions<mydbcontext> options) : base(options)     {      }      public dbset<assessment> assessorassessments { get; set; }     public dbset<assignment> assessorassignments { get; set; }      protected override void onmodelcreating(modelbuilder modelbuilder)     {         base.onmodelcreating(modelbuilder);          modelbuilder.entity<certificateevent>().totable(nameof(certificateevent));         modelbuilder.entity<assessment>().totable(nameof(assessment));         modelbuilder.entity<assignment>().totable(nameof(assignment));     } }  class mydesigntimedbcontextfactory : idesigntimedbcontextfactory<mydbcontext> {     public mydbcontext createdbcontext(string[] args)     {         var builder = new dbcontextoptionsbuilder<mydbcontext>();         builder.usesqlserver("server=(local);database=test;trusted_connection=true;multipleactiveresultsets=true");         return new mydbcontext(builder.options);     } }

i've tried dotnet ef migrations add inheritance, did not created tpt inheritance in database

tpt not in ef core (yet). see

the feeling our team tpt anti-pattern , results in significant performance issues later on. while enabling may make folks "happier" start leads issues. willing consider though, we're leaving open , consider based on feedback get.

https://github.com/aspnet/entityframeworkcore/issues/2266


Comments

Post a Comment

Popular posts from this blog

neo4j - finding mutual friends in a cypher statement starting with three or more persons -

Image
i trying build cypher statement neo4j know 2-n starting nodes name , need find node (if any) can reached of starting nodes. at first tought similar "mutual friend" situation handled (start1)-[*..2]->(main)<-[*..2]-(start2) in case have more 2 starting points around 6 know name. so puzzled how can include third, fourth , on node cypher able find commmon root amongst them. in above example neo4j website need path starting 'dilshad', 'becky' , 'cesar' check if have common friend (anders) excluding 'filipa' , 'emil' not friends of three. so far create statement programmatically looks like match (start1 {name:'person1'}), (start2 {name:'person2'}), (start3 {name: 'person3'}), (main) (start1)-[*..2]->(main) , (start2)-[*..2]->(main) , (start3)-[*..2]->(main) return distinct main but wondering if there more elegant / efficient way in cypher possibly use list of names parameter ...
Read more

php - How to remove letter in front of the word laravel -

Image
based on picture above result of var_dump() , dd() of same variable ,when var_dump() , apostrophe (') symbol in black diamond of question mark , when dd() same variable , apostrophe can seen letter 'b' appear in front of words what want can me result : loreal's sdn bhd and @ same time want remove special character ( excluding these 4 symbols (-) ,(_) ,('),(,) ) simply escape special character resolve issue. mysqli_real_escape_string resolve issue. $name = mysqli_real_escape_string($request()->user); or use addslashes function() $name = addslashes($request()->user);
Read more

linux - Why does bash short curcuit fail in crontab? -

if in terminal do [ $(/usr/bin/date +"%y%m%d") -le 20171209 ] && echo aaa >> /tmp/a it works. if in crontab -e * * * * * echo aaa >> /tmp/a then works. if in crontab -e * * * * * [ $(/usr/bin/date +"%y%m%d") -le 20171209 ] && echo aaa >> /tmp/a then nothing happens. looking @ /var/log/cron see sep 12 08:36:01 enote crond[8809]: (root) cmd ([ $(/usr/bin/date +") question can explain issue is? percent sign has special meaning in crontab, must escaped \% man 5 crontab /percent percent-signs (%) in command, unless escaped backslash (\), changed newline characters, , data after first % sent command standard input.
Read more