We\'re using the Entity Framework (MySQL connector) and are creating a central Search facility on our web application.
There are numerous post regarding LINQ and multiple joins. I have however not found any solution to the join I\'d like to make.
Basically I have the follwing: Dim ctx As New AdminCoreEntities Dim roles = (From r In ctx.Roles where r.Name.StartsWith(\"cust\") Select r) \'list of System.Linq.IQueryable(Of AdminCoreModel.Role)
To save multiple DB calls, and since it is from the same table, I\'m looking for one of the fields in my linq query to return an object with 2 fields that are IEnumerable.开发者_开发百科
I have a database view which I publish to other systems using WCF data services. The middle layer between the database and the WCF Data Services is built upon Entity Framework 4.1
I very new to Linq and Entity frame work, i have problem with my below code. I am getting error Unable to cast object of type\'<>f__AnonymousType1`2
I want to get the sum of applicants that applied to a specific position, this should not be saved as a column.
I have a linq statement that searches a number of fields based on user input from a form.Only 1 form field is required, thus I need to handle empty string values.Whats the best way to handle this.Shou
I need to round the sum of decimal?. I do: group => new { rounded_sum = gro开发者_Python百科up.Sum(f => f.A) == null ? null : (decimal?)Decimal.Round((decimal)group.Sum(f => f.A), 0),
How can I convert the string to datetime using linq to entities .... I have got the below query, where the visit_date column datatype is string...