I need to use stored procedure to get data from DB, but I would also like to use IQueryable to add some filtering to results. I\'m using subsonic and for now can\'t see a way to use subsonic sp and IQ
I have the following p开发者_运维百科roblem: In our database we record helpdesk tickets and we book hours under tickets. Between those is a visit report. So it is: ticket => visitreport => hours.
I am trying to write a unit test for a method which take开发者_如何学Pythons an IQueryable collection.
I am in a situation where i need to convert fields with DateTime to a Date (DateTime (2011-01-01 00:00:00 ) to Date ( 2011-01-01 just a string with no time )) before i assign the source to the DataGri
This is probably best explained with some code: 开发者_运维百科public IQueryable<DatabaseRecord> GetQueryableLinkedRecords()
Assume A is a parent table with many B records.Essentially I need LINQ to S开发者_运维问答QL to generate this query:
[update] I\'m sorry, i should tag this question as MVC-2, I pass result of query into view\'s model, so i must specify type
how do i cast to cartItem? var newItem = from i in dc.CartItems where i.productID == item.productID select new {productID = i.productID,
I\'m playing around and trying to make an extension method for IQueryable that sorts it by an arbitrary property of a object.
I found an example in the VS2008 Examples for Dynamic LINQ that allows you t开发者_运维百科o use a SQL-like string (e.g. OrderBy("Name, Age DESC")) for ordering. Unfortunately, the method in
加载中,请稍侯......