Return a count with linq-to-sql?

I want to return a count of new users since a specific date. Users table has: UserID, username, dateJoined. SELECT...

Purpose of EF 6.x DbContext Generator option when adding a new data item in Visual Studio?

I have a web app that I built using LINQ to SQL and I'm looking to upgrade it to LINQ to Entity Framework. I've look...

Linq version of SQL “IN” statement?

I have the following 3 tables as part of a simple "item tagging" schema: ==Items== ItemId int Brand varchar ...

LINQ: combining join and group by?

I have a query that combines a join and a group, but I have a problem. The query is like: var result = from p in P...

Convert simple SQL group-by into LINQ to SQL?

I'm having trouble. I can't understand existing answers to this on Stack Overflow and am too new to LINQ to SQL to b...

Linq-to-sql orderby thenby?

I'm using the following query syntax from table where where orderby orderby Where the first orderby is a date a...

C# Razor Syntax - html.displayfor displaying as text, not html?

My models: public class htmlDump { public string html { get; set; } } public string getSquares...

How to do a LIKE query with linq??

How can i perform an LIKE query within Linq? I have the following query i would like to execute. var results = fro...

Join two tables using LINQ Query and order based two parameters?

I have two tables Customers and Orders. I want a LINQ query to fetch list of all the orders placed by all the custom...

LINQ to SQL: Multiple joins ON multiple Columns. Is this possible??

Given: A table named TABLE_1 with the following columns: ID ColumnA ColumnB ColumnC I have SQL query where TABL...

linq to sql Distinct and orderby?

var result = table1.Join(table2, o => o.ProgramID, t => t.ProgramID, (o, t) => new { o.ProgramID, t.Program...

How to do Select All(*) in linq to sql?

How do you select all rows when doing linq to sql? Select * From TableA In both query syntax and method syntax pl...