Top "Linq-to-sql" questions

LINQ to SQL - How to select specific columns and return strongly typed list

I'm trying to use LINQ to SQL to select a few specific columns from a table and return the result …

asp.net linq-to-sql

how to update the multiple rows at a time using linq to sql?

Table: id userid friendid name status 1 1 2 venkat false 2 1 3 sai true 3 1 4 arun false 4 1 5 arjun false if user sends userid=1,friendids=2,4,5 status=…

c# linq entity-framework linq-to-sql

LINQ Where with AND OR condition

So I have managed to get this query working List<string> listStatus = new List<string>() ; listStatus.…

linq linq-to-sql where-clause

LINQ to SQL Left Outer Join

Is this query equivalent to a LEFT OUTER join? //assuming that I have a parameter named 'invoiceId' of type int …

.net database linq linq-to-sql

LINQ to SQL - Left Outer Join with multiple join conditions

I have the following SQL, which I am trying to translate to LINQ: SELECT f.value FROM period as p …

c# sql linq linq-to-sql outer-join

How do I update a Linq to SQL dbml file?

How do I update a Linq to SQL .dbml file?

linq-to-sql

LINQ to SQL using GROUP BY and COUNT(DISTINCT)

I have to perform the following SQL query: select answer_nbr, count(distinct user_nbr) from tpoll_answer where poll_…

c# linq linq-to-sql

Linq to SQL how to do "where [column] in (list of values)"

I have a function where I get a list of ids, and I need to return the a list matching …

linq linq-to-sql

How to do a join in linq to sql with method syntax?

I have seen lots of examples in LINQ to SQL examples on how to do a join in query syntax …

linq-to-sql ef-fluent-api

LINQ syntax where string value is not null or empty

I'm trying to do a query like so... query.Where(x => !string.IsNullOrEmpty(x.PropertyName)); but it fails... so …

linq linq-to-sql