System.InvalidOperationException: Nullable object must have a value. Linq to sql

Question

I am getting this error in one of my development machine. This error is not happening in other machine which is pointing to same database. Definitely both servers are not identical. I don't know what software which is missing in one server cause this issue. Both machine is running same OS 2008 R2.

using (MYDB.MyDB oDB = new MYDB.MyDB())
        {
            var query = from t in oDB.Products
                        where (_ProductId.HasValue?_ProductId==t.Productid:true)
                        select new Product()
                       {
                           ProductId = t.Productid,
                           ManufacturerId = t.Manufacturerid,
                           ManufacturingNumber = t.Manufacturingnumber,
                           CustomProduct = t.Iscustomproduct ? "Yes" : "No",
                           IsCustomProduct = t.Iscustomproduct,
                           SubCategoryName = t.Subcategory.Subcategoryname
                       };
            return query.ToList();
        }

Any help is highly appreciated

Thanks, Senthilkumar

musefan · Accepted Answer · 2013-04-15 09:20:21Z

1

I can not reproduce the exception in a comparable case, but the part _ProductId.HasValue?_ProductId==t.Productid:true looks suspect. I would change it as follows and if you're lucky it also solves your problem, otherwise it's an improvement anyway:

var query = from t in oDB.Products;
if (_productId.HasValue)
{
    query = query.Where(t => t.Productid == _productId.Value);
}
query = query.Select(t => new Product() {...

Another cause could be that Product.ProductId is not a nullable int.

edited Apr 15, 2013 at 9:20

musefan

48.5k21 gold badges144 silver badges193 bronze badges

answered Mar 28, 2012 at 20:10

Gert Arnold

110k36 gold badges218 silver badges319 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

System.InvalidOperationException: Nullable object must have a value. Linq to sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related