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...