I'm using the code below:...from c in Country
where c.IsActive.Equals(true)
orderby c.CountryName
select new
{
countryIDCode = c.CountryID + "|" + c.TwoDigitCode,
countryName = c.CountryName
}
...But when I use it, I get this error:...Unable to cast the type 'System.Int32' to type 'System.Object'. LINQ to Entities only supports casti...
I must transform a...string...
worth to...int...
LINQ to Entities does not seem to support this however....I'm receiving an error with the following code....var query = (from p in dc.CustomerBranch
where p.ID == Convert.ToInt32(id) // here is the error.
select new Location()
{
Name = p.Br...
How do I get an array in Linq to an entity?... continuation of the problem...but it is no longer an array => Dictionary.
Dictionary is the city type.... var sites = (from country in db.Countries
select new
{
Country = country.Title,
Cities = coun...
My first approach was as follows:...public virtual User GetUser(string username)
{
return _db.Users.Single(x => x.UserName == username);
}
...Basically, a linq method that retrieves users based on usernames....It wasn't always working since, as I discovered, the username sometimes came through with an uppercase letter at...
I want to use EF to store an object that has a List of primitives....public class MyObject {
public int Id {get;set;}
public virtual IList<int> Numbers {get;set;}
}
...Although I am aware of this, I would still want to learn about potential remedies....I can think of two solutions, which are:...1....Make a fake item.... with an Id and an in...
I have a table for purchases, thus I have this difficulty....Purchases(Date DateTime, Number string)
...The difficulty is that Number is a ...string... and I need the Max(Number) in order to create a new record....Purchases.Select(X=>int.Parse(X.Number)).Max()
...nonetheless, it could raise an exception, so I made a custom...ToInt()...
hence, when ...
I am attempting to filter the data that is returned to a Kendo combo box. Since the filtering is dependent on the ID, I must return all records that contain the filtration text rather than just those that match the criteria....Items = Mapper.Map<List<PurchaseOrder>, List<PurchaseOrderViewModel>>(
purchaseOrderRepository.GetMany(x =>...
If a buy order is 123456, for example, entering in 456 will return 123456 in the results. I want my users to be able to search for purchase orders (which are INTs) via partial strings....I believed that would work:... var pop = (from po in ctx.PurchaseOrders
let poid = po.PurchaseOrderID.ToString()
where poid.Co...
A conditional statement I have assesses a....Any()...
LINQ querying my database....When casting or converting a string to a long value, an error is being thrown....(long.TryParse(m.Reference,out t)? t : long.MaxValue)
...The mistake looks like this:...LINQ to Entities does not recognize the method '....' method, and this method cannot be translated...
