i trying change primary key in 1 of tables int uniqueidentifier. pointed out in title, taking database first approach using entity framework. the process took remove primary key table in sql designer , renamed column "itemid" "item". i created column named "itemid" , set uniqueidentifier type default newsequentialid(). then deleted column renamed "item" , set "itemid" primary key. i moved visual studio , did update model database gave me error error 1 error 2019: member mapping specified not valid. type 'edm.int32[nullable=false,defaultvalue=]' of member 'itemid' in type 'shoppingmodel.dbfruits' not compatible 'sqlserver.uniqueidentifier[nullable=false,defaultvalue=,storegeneratedpattern=identity]' of member 'itemid' in type 'shoppingmodel.store.dbfruits'. and here model under .tt directory public partial class dbfruits { public dbfruits() { thi...
can please me query working selecting data's tables wanted display fields connected other fields using recursive query. my table i have self query does'nt output connected , connected fibers query select closure_id, fiber_id , @pv:=fiber_id 'fiber_id2' (select * tbl_map_closure_fiber order closure_id) join (select @pv:=1)tmp closure_id=@pv just askin how can manage ouput both connected closure_id , connected fiber. please 1 . you need join table pair related rows. select t1.fiber_id, t2.fiber_id fiber_id2 tbl_map_closure_fiber t1 join tbl_map_closure_fiber t2 on t1.fiber_id = t2.closure_id http://sqlfiddle.com/#!9/3f83ee/2
Comments
Post a Comment