score:1
Accepted answer
var test = _
(from x in dc.mydatas
(select x.proc_code).asenumerable().
where(x => x.proceduredescription.contains("test"));
Source: stackoverflow.com
Related Query
- How to add custom columns to a table that LINQ to SQL can translate to SQL
- How can I turn SQL query that joins two columns and groups by count of one column and a column of each joined table into LINQ?
- How to add field not mapped to table in Linq to Sql
- How can you see the sql that is causing an error on SubmitChanges in LINQ to SQL?
- How do i prevent Linq from adding a GUID so that SQL server can do it?
- How to specify which columns can be returned from linq to sql query
- How do I write a LINQ to SQL statement with a custom function that needs the compare the current item context to a passed in value?
- How can I see the SQL text that is sent by LINQ to my database?
- C# SQL Statement transformed TO LINQ how can i translate this statement to a working linq
- How can I make a LINQ Select that includes a child object like a SQL outer join?
- How can I return all the columns of a table using multiple distinct columns in Linq
- How to use Data Binding Linq to SQL to add custom fields
- LINQ to Entities is pluralizing table names actually executed in SQL Server. How can I avoid it?
- How Can I add an XSI type to an element that is being serialized using LINQ
- How to write a Linq that can retrieve all parent table records and total of sub-table record, I mean 'separate' into two parts
- How to retrieve data with LINQ to SQL into a weakly-typed object that can be moved around
- How can I translate SQL query to LINQ Lambda Expression - Sum, LeftJoin, GroupBy
- how can I translate my SQL statement to LINQ
- How are people unit testing code that uses Linq to SQL
- How to return anonymous type from c# method that uses LINQ to SQL
- How can I implement NotOfType<T> in LINQ that has a nice calling syntax?
- How can you do custom sorting in LINQ with null always on the end?
- How can I set properties on all items from a linq query with values from another object that is also pulled from a query?
- How can I directly execute SQL queries in linq
- How can I convert this SQL Query into LINQ (OVER (PARTITION BY Date))
- How do I write this in Ruby/Python? Or, can you translate my LINQ to Ruby/Python?
- How can I add elements from one collection that do not exist in a second collection to a third collection?
- How can I use Left join in linq that we use in sql?
- How can I calculate sum of column value in linq to sql query?
- How can I achieve SQL CASE statement from LINQ
More Query from same tag
- If Entity Framework is meant to work with POCOs, then why the dependency on IObjectSet?
- LINQ join based on checkbox
- Check if list of string contains object property value, and if it does remove it from the list of strings
- Selecting most recent news article in a collection with Linq to Sql
- Queries in Linq
- Linq sort by string that is datetime
- How to group by multiple columns with complex types in Linq
- Selecting a child node having specific value
- Does LinqDataSource perform Server-Side paging by default?
- C# Determine Duplicate in List
- C# compiler error: Cannot convert lambda expression
- class cannot be constructed in a LINQ to Entities query
- Cache an IEnumerable vs List for lazy initialization
- Get the last record of group using LINQ
- How to fill a string with ordered elements via LINQ?
- Remap Lookup keys in C# using LINQ
- Linq Advanced Grouping + Count to new model
- Conversion error in Entity Framework
- How to write Linq Queries for CRUD operations using Entity Framework with Asp.Net?
- ILookup with empty collections
- How to return Linq query result from BLL layer to UI layer in C#
- How to Get Closest Location in LINQ to Entities
- Comparing and Merging Dictionaries using LINQ in C#
- How to determine if XElement.Elements() contains a node with a specific name?
- How can I get a value inside the select query using linq?
- LINQ - Flatten nested sequence so it is joined with the parent sequence
- Invert nested collections in LINQ
- Find out field of object in SortedList
- translating complex T-SQL query to LINQ to Entities
- Best way to compare two large string lists, using C# and LINQ?