LinQ Syntax of looping a collection

Hi.

I have the below SQL which works just fine:

SELECT     Message, CreateDate, AccountId, AlertTypeId
FROM       dbo.Alerts
UNION
SELECT     TOP (100) PERCENT Status, CreateDate, AccountId,
                          (SELECT     10 AS Expr1) AS AlertTypeId
FROM         dbo.StatusUpdates
WHERE AccountId = PassedInParameter
ORDER BY CreateDate DESC

I have been going about trying to convert the above into a LINQ method and am having problems with return types.
As the above SQL illustrates, I am querying two distinct LINQ tables - Alerts and StatusUpdates -
and then attempting to perform a Union on them. In order to do the union in LINQ, I have to have agreeing types. So, I
am using "var" to make the results of "alerts" and "updates" generic before the union.  

public IList GetStatusUpdatesAsAlertsByAccountId<T>(Int32 accountId)
        {
            using (WorkbookDataContext dc = _conn.GetCont

Hello

I have a GridView in my page. I want to use below code in code beind. query nothwing DB using linq . add linq query result to new list and then bind list as gridview Datasource

I use below code . But I don't know how to add results to List? Could any one tell me how !

Public Class OrderCity
        Private _name As String
        Private _city As String
        Public Property name As String
            Get
                Return _name
            End Get
            Set(ByVal value As String)
                _name = value

            End Set
        End Property
        Public Property city As String
            Get
                Return _city
            End Get
            Set(ByVal value As String)
                _city = value

            End Set
        End Property
    End Class
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        Dim dbe As New SFFAV1DataContext
        Dim latestadsDs = From p In dbe.Products _
                            Select New With {p.Title, p.ProducedCity} _
                             Take (2)

        Dim FilteredList As New List(Of OrderCity)()
        For Each result In latestadsDs
            Dim Menedfcou = Nothing
            FilteredList.Insert(0, Menedfcou)
        Next
     
         GridView1.Da

I am having a problem that creeps up over and over when using LINQ to SQL.  I am getting the error: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'WHERE'.

Now I have done a great deal of digging, and the only cause I can seem to find is when users are overriding the Equals() or GetHasCode() methods of the generated classes.  I am not overriding either.  I am getting this error on two different project with two different databases.  I have tried everything every post I have found suggests.  I have even scrapped my dbml file and re-created, all to no avail.

Anyone have any thoughts?  They would be greatly appreciated!

Hi,

I'm having one of those brain-shuddering moments where I know the answer in SQL but can't get it quite right using LINQ to dataset - anyone help?

var deals =                                                      
    from m in dtM AS Enumerable()                  // first part of query
    select m.Field<Int32>("MerchantIdId")       // runs down a standard table or list

    (from d in dtD AS Enumerable()                 // sub query
    orderby d.Field<Int32>("Seq")                   // returns first occurrence of a deal in table
    select d.Field<Int32>("DealId")).FirstOrDefault()

// the two need bolting together so that for each record in dtM, I return the first
// occurrence of DealId in dtD

Thanks in advance.

*** update ***

I suppose what i'm lookin is nearly the equivalent of this which i found whilst searching:

SELECT OrderID, OrderDate

FROM OrderTable

WHERE CustomerID = (SELECT CustomerID

                  &nb

say now i wanna do this type of linq:

{
IEnumerable<MyStuff> r1 = from ....;

var rslt = from r2 ....
 join r1 ....
 where MyEval(r2.Field1, r1) ... <= #A
}

Func<Field1DataType, IEnumerable<MyStuff>, bool> <= #B

How do i code the #B ?

should I code it as a variable within the routine, or outside as a routine itself?

Folks,

I would like to know whether people use the join syntax OR projection when joining entities in LINQ to SQL queries. I have noticed that when using projection that a CROSS JOIN is in the generated SQL

e.g. 

var query =
from o in Orders
from  oi in o.OrderItems
where oi.OrderId == o.OrderId

generates SQL something like...

FROM [Customer].[Orders] AS [t0]
CROSS JOIN [Customer].[OrderItems] AS [t1]
WHERE ([t1].[OrderId] = [t0].[OrderId]) AND ([t1].[OrderId] = [t0].[OrderId])

whereas with explicit joins I get a clean inner join..

var query =
from o in Orders
join oi in OrderItems on o.OrderId equals oi.OrderId

generates..

FROM [Customer].[Orders] AS [t0]
INNER JOIN [Customer].[OrderItems] AS [t1] ON [t0].[OrderId] = [t1].[OrderId] 

I know using explicit joins over projection is frowned upon, but I am wary of those cross joins.

Just wondering what other folks preferences are when using joins in L2SQL.

Cheers

K

I have a site collection at http://[server]:[port]/sites/[name].  When I try to execute a linq query I get an exception saying that the web at http://[server]:[port]/sites/[name] cannot be found.  If I pass http://[server]:[port] to the datacontext that web is found, but the SPList I am trying to query cannot be found.

From looking online I know you cannot (without workarounds) query cross site collections, but I don't want to do that.  How do I connect to the specific site collection at http://[server]:[port]/sites/[name] with linq to sharepoint?

Sorry for the vague subject title.

A UserControl has an ObservableCollection

the UserControl is instantiated in MainWindow.xaml

I want to specify the collection defined within the usercontrol as a resource in MainWindow.xaml

I thought the syntax might be like the following

<Window.Resources>

<local:myUserControl.MyCollection x:key="whatever"/>

....

However this produces an error "The attachable property 'MyCollection' was not found in type 'myUserControl'