Top "Linq-to-sql" questions

LINQ to SQL is a component of .NET Framework version 3.5 that provides a run-time infrastructure for managing relational data as objects stored in Microsoft SQL Server.

LINQPad [extension] methods

Does anyone have a complete list of LINQPad extension methods and methods, such as .Dump() SubmitChanges()

c# .net entity-framework linq-to-sql linqpad
How to write Asynchronous LINQ query?

After I read a bunch of LINQ related stuff, I suddenly realized that no articles introduce how to write asynchronous …

c# linq linq-to-sql asynchronous
Group Multiple Tables in LINQ

I have a very simple SQL query: SELECT r.SpaceID, Count (*), SpaceCode FROM Rider r JOIN Spaces s ON r.…

c# sql linq linq-to-sql
What is difference between .edmx and .dbml file in linq?

What is difference between .edmx and .dbml file in linq?In VS 2008 which datasource is best choice where edmx or …

linq linq-to-sql entity-framework linq-to-entities
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 …

c# asp.net entity-framework linq linq-to-sql
How to use transactions with a datacontext

Can I use transactions with a datacontext, so that I can rollback the state of the context after an error? …

c# linq linq-to-sql transactions datacontext
Understanding .AsEnumerable() in LINQ to SQL

Given the following LINQ to SQL query: var test = from i in Imports where i.IsActive select i; The interpreted …

c# linq linq-to-sql asenumerable
How to do a full outer join in Linq?

I've inherited a database that wasn't designed exactly optimally, and I need to manipulate some data. Let me give a …

c# linq linq-to-sql outer-join full-outer-join
Create a DbSet<T> dynamically in Entity Framework?

In LINQ to SQL, I can create a repository dynamically using DataContext.GetTable<T>. Is there a similar …

c# linq-to-sql entity-framework-4 ef-code-first dbset
Which SQL Server field type is best for storing price values?

I am wondering what's the best type for a price field in SQL Server for a shop-like structure? Looking at …

c# sql-server linq-to-sql database-design query-optimization