DataContext is LinqToSql. LinqToSql is for SqlServer only.
Perhaps you meant to use LinqToEntities and ObjectContext?
If one wants to use LINQ to SQL for RDBMS other than Microsoft SQL Server, a third-party assembly is required. DBLinq is a project that provides LINQ to SQL functionality for other (open-source) databases.
Npgsql can be configured as a db provider for Entity Framework following the documentation on this Npgsql blog:
- npgsql LINQ creates SQL Server sql syntax
- Syntax to execute code block inside Linq query?
- LINQ Source Code Available
- creating Linq to sqlite dbml from DbLinq source code
- Accessing SQL Server time in code with LINQ
- source code for LINQ 101 samples
- c# Linq or code to extract groups from a single list of source data
- Need Help Translating SQL Server UNION Syntax to LINQ
- Translate SQL SERVER SELECT to LINQ with multiple join Method Syntax
- Convert string to int in one line of code using LINQ
- Code equivalent to the 'let' keyword in chained LINQ extension method calls
- Linq Syntax - Selecting multiple columns
- Linq code to select one item
- What can I do to resolve a "Row not found or changed" Exception in LINQ to SQL on a SQL Server Compact Edition Database?
- Using LINQ extension method syntax on a MatchCollection
- Is there a C# LINQ syntax for the Queryable.SelectMany() method?
- LINQ - Query syntax vs method chains & lambda
- How are people unit testing code that uses Linq to SQL
- LINQ group by expression syntax
- LINQ syntax where string value is not null or empty
- How does LINQ expression syntax work with Include() for eager loading
- .NET LINQ query syntax vs method chain
- left outer join in lambda/method syntax in Linq
- What's the equivalent VB.NET syntax for anonymous types in a LINQ statement?
- How to Connect to SQL Server using LINQ to SQL?
- Linq syntax for OrderBy with custom Comparer<T>
- GroupBy with linq method syntax (not query syntax)
- LINQ Lambda vs Query Syntax Performance
- LINQ query to perform a projection, skipping or wrapping exceptions where source throws on IEnumerable.GetNext()
- How to Convert LINQ Comprehension Query Syntax to Method Syntax using Lambda
- Linq to SQL query taking forever
- C# (String.StartsWith && !String.EndsWith && !String.Contains) using a List
- unknown column 'extent3.id' in 'where clause'
- Int.Parse in Linq Expression
- LINQ to Entities does not recognize the method 'System.String ToString(Int32)' method, and this method cannot be translated into a store expression
- Using Linq to get the last N number of rows that have duplicated values in a field
- Sort by most recent date and cluster (group) similar titles
- How to write this WHERE condition in Linq?
- LINQ join - two objects by different "type" of parameters
- filter child entities while fetching a parent entity EF Core
- Find gap in datetime range with Linq to sql in vb.net
- linq latests elements that match a criteria
- Where does "i" get its value in this LINQ statement?
- How to write this query as lambda expression?
- Sub query in linq to sql
- How can I combine these linq queries into one?
- Error in dynamic sorting with linq
- How can I sort generic list DESC and ASC?
- Group users by age for a range
- C#: Altering values for every item in an array