BP Forums
What is LINQ to SQL? - Printable Version

+- BP Forums (https://bpforums.info)
+-- Forum: Archived Forums (https://bpforums.info/forumdisplay.php?fid=55)
+--- Forum: Archived Forums (https://bpforums.info/forumdisplay.php?fid=56)
+---- Forum: VB.NET (Visual Basic 2010/2008) (https://bpforums.info/forumdisplay.php?fid=8)
+----- Forum: Programming Help (https://bpforums.info/forumdisplay.php?fid=9)
+----- Thread: What is LINQ to SQL? (/showthread.php?tid=610)



What is LINQ to SQL? - Moldraxian - 08-20-2012

I've been doing some research and I've been seeing many things about something called LINQ. It looks like a way to build complicated SQL queries but it is very hard to understand. Does anyone have any tips that would help LINQ make more sense?

I made my own query and I had this error pop up:
Cannot perform 'Like' operation on System.DateTime and System.String.

I don't understand why I get this error but this is my code.
Code:
Private Sub txtOrder_TextChanged(sender As System.Object, e As System.EventArgs) Handles txtOrder.TextChanged
        If txtOrder.TextLength > 0 Then
            All_flood_certsBindingSource.Filter = String.Format("[Order Received] Like '" & txtOrder.Text) & "'"
        Else
            All_flood_certsBindingSource.Filter = String.Empty
        End If
    End Sub