Can somebody please help me to find out the solution with this problem?
I'm trying to insert the data into my database which has 2 tables
Products
(ProductID): 1
(IDNumber) : 200900110
(ProductName) : Pepsi
Order
(OrderID): 1 (Auto Increment by 1)
(ProductID):1
(Date): 1/1/2009
The code is this:
var db = new ProductOrder();
var idNum = from p in db.Product
where p.IDNumber == 200900110
select p.ProductID;
var order = new Order();
order.productID = Convert.ToInt32(idNum);
order.Date = DateTime.Now;
db.Order.InsertOnSubmit(nTime);
db.SubmitChanges();
After I run it gives me the error like this :
Unable to cast object of type 'System.Data.Linq.DataQuery`1[System.Int32]' to type 'System.IConvertible'
.
May someone please check this code for me? Thanks in advances.