.net - Anyone using the Entity Framework *Well*? -

-

has shipped entity framework project o/r mapping conceptual classes quite different tables in datastore?

i mean collapse junction (m:m) tables other entities form conceptual classes exist in business domain organized multiple tables in datastore. examples see on msdn have little use of inheritance, collapsing junction tables other entities, or collapsing lookup tables entities.

i'd love hear of or see examples of below support crud operations typically expect on business object.:

  1. vehicle table , color table. color can appear in many vehicles (1:m). form conceptual class usedcar has property color.

  2. doctor, doctorpatients, , patients tables (form many many). doctors have many patients, patients can have many doctors (m:m). map out 2 conceptual classes doctor (which has patients collection) , patients (which has doctors collection).

anyone seen/done csdl , ssdl in entity framework? csdl no if doesn't actaully map anything!

i attempted use entity framework on existing project (~60 tables, 3 inheritance) see about. experience boiled down to:

the designer surface kludgy. mapping isn’t intuitive , must have thought having several tool windows open @ same time acceptable. took long time manually create object , map right fields – still odd talking code. while having handling database communication essential, i feel handing control on ef far more of fight doing manually.

sometimes designer doesn’t load until restart visual studio. i’m sure it’s bug restarting vs annoying.

all work ends in single file, i’d hate merge multiple developer editions.

the resultant sql (watched via profiler) wasn’t good. didn’t delve looking why, you’d pressed write worse on first attempt.


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more