I can't figure out what is going on here.  I am using linq to query my sql database.  If I set my code to be a "CodeFile", then I get the following error...

Compilation Error

Line 57:             DataDataContext _db = new DataDataContext();
Line 58: 
Line 59:             var _devices = from d in _db.empact_Devices
Line 60:                            where d.empact_DeviceType.DeviceTypeName == "Buoy"
Line 61:                            select d;

If I change it to a "CodeBehind" and compile my project, then the page renders fine. Any reason why this would be happening?  Most of my other pages are CodeFile pages.  

Thanks,

Joe 

 Just a guess but are you importing the linq namespaces in your codefile page? Maybe if it doesnt have the namespace then its tripping up the compiler trying to parse the code?

What about if you rewrite it the other way (forgot the name) like

var _devices = _db.empact_Devices.Select(d => d.empact_DeviceType.DeviceTypeName == "Buoy");

Thanks for responding.  I re-wrote the query and got the following error...
 

Compiler Error Message: CS1525: Invalid expression term '>'

 Also these are the namespaces I have been using...

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

Thanks,

Joe
 

joero42:

Invalid expression term '>'

There is no ">" in your code (above)... you'll need to show the current version (use cut & paste, not retyping it).

Also, for LINQ to SQL (use of  DataContext), you will need the namespace System.Data.Linq.

I didn't cut and paste it in because it didn't help me solve my problem.  It still works fine if the page is compiled as code-behind and not as a code-file.  So no matter what way you write the query it still failed when used in a code file.  I am not using a DataContext, as I'm not using Linq to SQL.  I'm simply querying a collection. 

 Thanks,

Joe
 

joero42:

I am not using a DataContext, as I'm not using Linq to SQL. 

We will not be able to help without a complete, but short, recreate, because the errors you are asking for help with do not relate to the code samples you have posted (and you have not defined things, so we have to guess from the names).