sql server - EF4 - The selected stored procedure returns no columns -

-

i have query in stored procedure calls linked servers dynamic sql. understand ef doesn't that, listed columns returned. yet, still doesn't that. doing wrong here? want ef able detect columns returned stored procedure can create classes need.

please see following code makes last lines of stored procedure:

select     #tempmain.id,     #tempmain.class_data,     #tempmain.web_store_class1,     #tempmain.web_store_class2,     #tempmain.web_store_status,     #tempmain.cur_1pc_cat51_price,     #tempmain.cur_1pc_cat52_price,     #tempmain.cur_1pc_cat61_price,     #tempmain.cur_1pc_cat62_price,     #tempmain.cur_1pc_cat63_price,     #tempmain.flat_length,     #tempmain.flat_width,     #tempmain.item_height,     #tempmain.item_weight,     #tempmain.um,     #tempmain.lead_time_code,     #tempmain.wp_image_nme,     #tempmain.wp_mod_dte,     #tempmain.catalog_price_chg_dt,     #tempmain.description,     #tempmain.supersede_ctl,     #tempmain.supersede_pn,     tempdesc.cust_desc,     tempmfgr.mfgr_item_nbr,     tempmfgr.mfgr_name,     tempmfgr.vendor_id     #tempmain         left join tempdesc on #tempmain.id = tempdesc.id         left join tempmfgr on #tempmain.id = tempmfgr.id

ef doesn't support importing stored procedures build result set from:

  • dynamic queries
  • temporary tables

the reason import procedure ef must execute it. such operation can dangerous because can trigger changes in database. because of ef uses special sql command before executes stored procedure:

set fmtonly on

by executing command stored procedure return "metadata" columns in result set , not execute logic. because logic wasn't executed there no temporary table (or built dynamic query) metadata contains nothing.

you have 2 choices (except 1 requires re-writing stored procedure not use these features):

  • define returned complex type manually (i guess should work)
  • use hack , adding stored procedure put @ beginning set fmtonly off. allow rest of sp's code execute in normal way. make sure sp doesn't modify data because these modifications executed during import! after successful import remove hack.

Comments

Post a Comment

Popular posts from this blog

ruby - Trying to change last to "x"s to 23 -

-
i have been playing around irb , have string looks this: irb(main):072:0> puts ["[\"4354 5432 5432 xxxxx\", \"6547 6547 8543 xxxxx\", \"2344 6543 6674 xxxxx\", \"2346 6236 7543 xxxxx\", \"1273 5585 5587 xxxxx\"]"] => nil irb(main):073:0> what want gsub last 2 "x" s of each 17 digit combination, 23 . what i've tried far (i've been using rubular): a.gsub(/\d[x]/,"23") <= grabs "x" s i'm close a.gsub(/\w[x{2}]/,"23") <= grabs "x" s grabs two digits each combination. is there easier way i'm not understanding? a.gsub(/\d{4} \d{4} \d{4} xxx\kxx/, '23') \d{4} = 4 digits what \k drop matched far. can use don't replace entire number, still able validate have in desired format.
Read more

jquery - Clone last and append item to closest class -

-
this bare-bones code on page: <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <di
Read more

c - Unrecognised emulation mode: elf_i386 on MinGW32 -

-
i'm trying make kernel, , cannot link c output assembly. ld . i'm getting error: unrecognized emulation mode: elf_i386 i'm using windows 10 professional mingw32 , msys. code using: link.ld /* * link.ld */ output_format(elf32-i386) entry(start) sections { . = 0x100000; .text : { *(.text) } .data : { *(.data) } .bss : { *(.bss) } } kernel.c /* * kernel.c */ void kmain(void) { const char *str = "my first kernel"; char *vidptr = (char*)0xb8000; //video mem begins here. unsigned int = 0; unsigned int j = 0; /* loops clears screen * there 25 lines each of 80 columns; each element takes 2 bytes */ while(j < 80 * 25 * 2) { /* blank character */ vidptr[j] = ' '; /* attribute-byte - light grey on black screen */ vidptr[j+1] = 0x07; j = j + 2; } j = 0; /* loop writes string video memory */ while(str[j] != '\0') { /
Read more