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.

.net - Constraining time with LINQ -


i'm having difficulty constraining time in linq statement. still pretty new linq. sql want emulate this:

select id, token, starttime  tokens  token = '050'  , starttime > dateadd(mi, -30, current_timestamp) 

this sql statement gets rows time in starttime column less 30 minutes current time. how linq? far best guess

datetime cutoff = datetime.now - new timespan(0, 30, 0); ienumerable<tokens> token = datacontext.tokens.where(row => row.token == "050" &&                                                              row.starttime > cutoff); 

but doesn't seem working. advise?

you may add 30 days token's starttime , compare current date. should compare token text string (double quotes), possibly might varchar2 type.

var token = datacontext.tokens.where(r =>    r.token == "5" &&    r.starttime.adddays(30).date >= datetime.now.date ); 

edit: want show last 30 days of operation, date , time should rounded date - changed code.


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 -