Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query Problem
Message
From
11/08/2010 12:48:20
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
General information
Forum:
ASP.NET
Category:
LINQ
Title:
Miscellaneous
Thread ID:
01476194
Message ID:
01476227
Views:
36
>>>>>>>I'm trying to retrieve an application from my database. I have a Data Context in my app called AppSecurityDataDataContext. Here's my query:
>>>>>>>
>>>>>>>
>>>>>>>{ 
>>>>>>>    AppSecurityDataDataContext dc = new AppSecurityDataDataContext();
>>>>>>>    var app = from a in dc._Applications
>>>>>>>                where a.ApplicationId = ApplicationID
>>>>>>>                select a;
>>>>>>>
>>>>>>>}
>>>>>>>
>>>>>>>
>>>>>>>I'm getting "Could not find an implementation of the query pattern for source type 'System.Data.Linq.Table<AppSecurity._Application>'. 'Select' not found. Are you missing a reference to 'System.Core.dll' or a using directive for 'System.Linq'?"
>>>>>>>
>>>>>>>I have the using statement in my class. This other method works:
>>>>>>>
>>>>>>>
>>>>>>>public static void AddApplication(Application Application)
>>>>>>>{
>>>>>>>    _Application app = new _Application
>>>>>>>    {
>>>>>>>        ApplicationName = Application.ApplicationName
>>>>>>>    };
>>>>>>>
>>>>>>>    _DataContext._Applications.InsertOnSubmit(app);
>>>>>>>
>>>>>>>    try
>>>>>>>    {
>>>>>>>        _DataContext.SubmitChanges();
>>>>>>>    }
>>>>>>>    catch (Exception e)
>>>>>>>    { 
>>>>>>>    }
>>>>>>>}
>>>>>>>
>>>>>>>
>>>>>>>Anyone see what's wrong here?
>>>>>>
>>>>>>==
>>>>>
>>>>>umm, huh? What does "==" mean?
>>>>Not the same as "=":
where a.ApplicationId = ApplicationID
>>>
>>>If I remove the Where clause, the comp error still occurs
>>
>>Then it looks as if it indeed isn't able to reference the System.Linq namespace (Your second example isn't using Linq). Are you sure you have a reference to the System.Core.dll in the project?
>
>
>My bad. I was using System.Data.Linq, not System.Linq. Not it works.
>
>So that begs the question: What the difference between the two?

I'm guessing System.Data.Linq is for Linq to DataSets.
Very fitting: http://xkcd.com/386/
Previous
Reply
Map
View

Click here to load this message in the networking platform