How to use wildcards with LINQ?

Question

How do I modify a LINQ query so that orgainizationName includes wildcards? If organizationName is "ABC," I need "ABC (Miami, FL)." The template is always orgName followed by a space, and then in parentheses "()" is the city and state.

var orgId = dc.Contacts.Where(on =>
on.ContactTypeID == 2 &&
on.IsActive == true &&
on.OrganizationName.Contains(organizationName)
)
.Select(on => on.ContactID).SingleOrDefault();

Thank!

Answer 1

on.OrganizationName.StartsWith(organizationName + " (");

Answer 2

var orgId = dc.Contacts.Where(on =>
    on.ContactTypeID == 2 &&
    on.IsActive == true &&
    on.OrganizationName.StartsWith(organizationName))
        .Select(on => on.ContactID).SingleOrDefault();

Answer 3

you can use on.OrganizationName.StartsWith(organizationName)