WHERE LIKE / NOT LIKE (LINQ, Entity Framework)

        private void frmMain_Load(object sender, EventArgs e)
        {
            // Create new entities Object
            using (var db = new myDatabaseEntities())
            {
                // String Name for search
                string strName = "J";

                // Get data from CUSTOMER
                var customer = (from c in db.CUSTOMER
                                where c.NAME.Contains(strName)
                          select c).ToList();

                // if found item rows
                if (customer.Count() > 0)
                {
                    this.myDataGridView.DataSource = customer;
                }
            }
        }

    Private Sub frmMain_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        ' Create new entities Object
        Using db = New myDatabaseEntities()
            ' String Name for search
            Dim strName As String = "J"

            ' Get data from CUSTOMER
            Dim customer = (From c In db.CUSTOMER
                            Where c.NAME.Contains(strName)
                            Select c).ToList()

            ' if found item rows
            If customer.Count() > 0 Then
                Me.myDataGridView.DataSource = customer
            End If
        End Using
    End Sub

where !c.NAME.Contains(strName)

where Not c.NAME.Contains(strName)