LINQ To SQL LIKE Operator - Generating LIKE in SQL Server Statements

LINQ To SQL LIKE Operator - Generating LIKE in SQL Server Statements

by David Hayden ( Florida .NET Developer ), Filed LINQ To SQL Tutorials

 

LINQ To SQL will generate the LIKE Operator in your WHERE clauses just like you would expect when you search for items in a table using StartsWith, EndsWith, and Contains in your LINQ To SQL Queries.

 

1. Example of LINQ To SQL Query using StartsWith.

 

View.Customers = from c in db.Customers
                            where c.ContactName.StartsWith("c")
                             orderby c.CompanyName
                            select c;


exec sp_executesql N'SELECT [t0].[CustomerID],...
FROM [dbo].[Customers] AS [t0]
WHERE [t0].[ContactName] LIKE @p0
ORDER BY [t0].[CompanyName]',
'N'@p0 nvarchar(2)',@p0=N'c%'

 

2. Sample LINQ To SQL Query Using EndsWith.

 

View.Customers = from c in db.Customers
                            where c.ContactName.EndsWith("c")
                             orderby c.CompanyName
                            select c;


exec sp_executesql N'SELECT [t0].[CustomerID],...
FROM [dbo].[Customers] AS [t0]
WHERE [t0].[ContactName] LIKE @p0
ORDER BY [t0].[CompanyName]',
'N'@p0 nvarchar(2)',@p0=N'%c'

 

3. LINQ To SQL Tutorial Using Contains:

 

View.Customers = from c in db.Customers
                            where c.ContactName.Contains("c")
                             orderby c.CompanyName
                            select c;


exec sp_executesql N'SELECT [t0].[CustomerID],...
FROM [dbo].[Customers] AS [t0]
WHERE [t0].[ContactName] LIKE @p0
ORDER BY [t0].[CompanyName]',
'N'@p0 nvarchar(2)',@p0=N'%c%'

 

It make perfect sense that LIKE Operators would be generated in SQL Server using StartsWith, EndsWith, and Contains, but I was still pretty impressed that it all work as expected.

 

LINQ To SQL Tutorials

• LINQ To SQL Enum Support Example Using Discriminator Column and Inheritance Mapping
• LINQ To SQL Discriminator Column Example - Inheritance Mapping Tutorial
• LINQ To SQL Attach Method for Attaching Detached Business Entities - DataContext.Attach
• LINQ To SQL and Visual Studio 2008 Performance Update
• LINQPad - Dynamically Query SQL Server Databases in LINQ
• LINQ To SQL Debugger Visualizer Revisited - Same Concerns Better UI :)
• DataContext.Log - Logging LINQ To SQL Output to Console or Debugger Output Window
• LINQ To SQL Debugger Visualizer in Visual Studio 2008 Has Limited Value - LINQ To SQL Tutorials
• LINQ To SQL As Replacement To Data Access Guidance Package
• LINQ Data Access Layer - Creating Insert Update Delete Stored Procedures
• Creating Data Access Layer Using LINQ To SQL - Stored Procedures Support
• LinqDataSource - High Performance Queries Using DataLoadOptions - Avoiding Database Roundtrips
• LINQ to SQL - Performance Tradeoffs: Less Database Roundtrips but Duplicated Data in Each Row??
• LINQ To SQL - Lazy Loading Properties and Specifying PreFetch When Needed - Sweet Query and Performance Control
• LINQ To SQL Video - Getting From Expression Trees to SQL

 

Source Feed: David Hayden ( Florida .NET Developer ), Filed LINQ To SQL Tutorials

posted on Friday, November 23, 2007 9:53 AM