Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

c# - Getting correct auto incremented ID in Oracle DB -


i inserting 1 row oracle database table, primary key id autoincrement. , retriving autoincremented id table.

in case of many people using same table. may run consumer producer problem may id of other user.

some of user on mentioned getting these incremented id based on connection not result in consumer producer problem:

just want check below things so:

first:

will exact autoincremented id below sceneario:

1) 2 computer in different subnet using db. 2) 2 computer wiht in same subnet using db. 3) 2 process using using db connection. 4) 2 thread uisng db connection. 

second:

 if insert is:  insert tables (id,name,description) values (dbnull,'name','description');   should query autoincremented id generated above  insert.  c# related command :) 

you should use returning clause:

declare     v_id tables.id%type; begin     insert tables (id,name,description)     values (seq.nextval,'name','description')     returning id v_id; --     dbms_output.put_line(v_id); end;  

this way id gets inserted instead of having requery highest id , hoping right one.


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -