c# - LINQ to SQL: Invalid column name 'DepartureGate', even though the column exists -

i absolutely not this. column exists in table, i've ensured application executing query against proper table in proper database, , still reports it's invalid column name.

i'm running net 4.0, sql server 2008 express edition. have similar experience?

executing queries against other column name in same table in same database works extremely excellently. added column today , reason application refuses acknowledge existence of column.

relevant column definition:

relevant code:

(from x in flightdatacontext.flightdatas x.flightdataid == flightdataid && x.departure == true select new {   x.arrivalstationcode,   x.arrivalstationname,   x.departuretime,   x.departuregate }).singleordefault(); 

i faced same problem.you can try following solutions.

you should update classes after database changed(drag , drop tables linq sql file), column accessible object name. if still problem exists value saving in coloumn greater size specified coloumn. try varchar(max) if coloumn of varchar type.