{"id":4423,"date":"2008-05-07T19:54:00","date_gmt":"2008-05-07T19:54:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/vbteam\/2008\/05\/07\/converting-sql-to-linq-part-10-like-bill-horst\/"},"modified":"2024-07-05T14:25:38","modified_gmt":"2024-07-05T21:25:38","slug":"converting-sql-to-linq-part-10-like-bill-horst","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/vbteam\/converting-sql-to-linq-part-10-like-bill-horst\/","title":{"rendered":"Converting SQL to LINQ, Part 10: Like (Bill Horst)"},"content":{"rendered":"

This post assumes you’ve read my previous Converting SQL to LINQ<\/a> posts.<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

I haven’t had much in the way of specific requests for more LINQ posts, so I’d still welcome any suggestions that people want to offer.  <\/span>I did get one request about how to mimic the LIKE keyword functionality in VB LINQ.<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

In SQL, the LIKE keyword compares a string field against a pattern and returns a Boolean value representing whether the string matches the pattern.  <\/span>For example, if I wanted to select every customer in the 206 area code, I could use this SQL query:<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n\n\n\n\n
\n

SQL<\/p>\n

<\/span><\/b><\/p>\n<\/td>\n<\/tr>\n

\n

SELECT *<\/p>\n

<\/span><\/p>\n

FROM CustomerTable<\/p>\n

<\/span><\/p>\n

WHERE Phone LIKE ‘206*’<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

The LIKE expression can include certain wildcard characters, which may differ from system to system.  <\/span>In the above example, * matches any string, so ‘206*’ represents any string that begins with 206.<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

VB happens to include a Like operator, so this is an easy conversion to make.  <\/span>The LINQ version of this above SQL expression is specified below:<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n\n\n\n\n
\n

VB<\/p>\n

<\/span><\/b><\/p>\n<\/td>\n<\/tr>\n

\n

From Contact In CustomerTable _<\/p>\n

<\/span><\/p>\n

Where Contact.Phone Like “206*”<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

The VB Like keyword has the following wildcards:<\/p>\n

<\/span><\/p>\n

          <\/span>?        <\/span>          <\/span>Matches any single character<\/p>\n

<\/span><\/p>\n

          <\/span>*        <\/span>          <\/span>Matches zero or more characters<\/p>\n

<\/span><\/p>\n

          <\/span>#       <\/span>          <\/span>Matches any single digit<\/p>\n

<\/span><\/p>\n

          <\/span>[ charlist<\/i> ]     <\/span>Matches any single character in the charlist<\/i><\/p>\n

<\/span><\/p>\n

          <\/span>[! charlist<\/i> ]    <\/span>Matches any single character not in the charlist<\/p>\n

<\/i><\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

More extensive documentation of the Like operator can be found here<\/a>.<\/p>\n

<\/strong><\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/b><\/p>\n

–      <\/span><\/span><\/span>Bill Horst, VB IDE Test<\/span><\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

This post assumes you’ve read my previous Converting SQL to LINQ posts.   I haven’t had much in the way of specific requests for more LINQ posts, so I’d still welcome any suggestions that people want to offer.  I did get one request about how to mimic the LIKE keyword functionality in VB LINQ.   […]<\/p>\n","protected":false},"author":260,"featured_media":8818,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[20,195],"tags":[41,49,94,166],"class_list":["post-4423","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-converting-sql-to-linq","category-visual-basic","tag-bill-horst","tag-converting-sql-to-linq","tag-linqvb9","tag-vb2008"],"acf":[],"blog_post_summary":"

This post assumes you’ve read my previous Converting SQL to LINQ posts.   I haven’t had much in the way of specific requests for more LINQ posts, so I’d still welcome any suggestions that people want to offer.  I did get one request about how to mimic the LIKE keyword functionality in VB LINQ.   […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/4423","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/users\/260"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/comments?post=4423"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/4423\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/media\/8818"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/media?parent=4423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/categories?post=4423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/tags?post=4423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}