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# - How do i modify Linq generated sql statement? -


i have summarized problem in following code.

northwinddatacontext dc = new northwinddatacontext();         var query = c in dc.customers                     select c; 

above code generating following sql statement

     select [t0].[id], [t0].[firstname], [t0].[lastname] [dbo].[customer] [t0] 

now want modify above generated query this

 select [t0].[id], [t0].[firstname], [t0].[lastname] [dbo].[customer]  [t0] (nolock)  

is possible in linq modify generated query?if yes how?

i have found handy tips modifying linq generated sql statement.

 northwinddatacontext db = new northwinddatacontext();             if (db.connection.state == system.data.connectionstate.closed)                 db.connection.open();             var cmd = db.getcommand(db.customers.where(p => p.id == 1));             cmd.commandtext = cmd.commandtext.replace("[customers] [t0]", "[customers] [t0] (nolock)");             var results = db.translate(cmd.executereader());  

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 -