sql server - Entity Framework inheritance and many to many mapping -

-

this tehnically 2 problems think allready know solution first i'll post here check.

i'm using entity framework 6, , building model database first way. in database significan interactions (inserting , modifying) handled through stored procedures (mainly can additional database side perimision checks).

first problem i'm trying build school's database. have 2 tables profesors , students. have aditional tabla called personaldata contains personal data info names, surnames , such. profesor , student tables in 1:0.1 relationships personaldata, meaning every single profesor there has personaldata record. same students. not every record in personaldata must student or profesor, of them parents.

at first tried implement in ef tpt inheritance, problems may arise if student becomes @ point professor. due way ef handles inheritance personaldata collection contain 2 entities same id.

i have googled bit , have found out using inheritance in these kind of cases impossible, , i'll need go accessing personal data throgh relationships, cause possible problem due fact i'll have manually make sure personalrecord added every student/professor. unless has better idea?

second problem due fac i'm using stored procedures inserting , updating data. have fiew many many relationships in db, , when import tables many many related, see no way map relationship (it's table) procedure.

so know how map many many relationships stored procedures in model designer?

as many many mapping stored procedures, seems it's impossible now. can attach instead of triggers join table, or view representing table. methid using view causes problems since ef treats views readonly, you'll need manually edit emdx , change view's type view table. make ef treat view table. if using view method, ef model designer won't turn view representing cross table association automatically. you'll have add assoc manually, map manually , delete view entity doesn't cause error since 2 things mapping same object (association , entity).


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more