score:2
DataContext
DataContext is LinqToSql. LinqToSql is for SqlServer only.
Perhaps you meant to use LinqToEntities and ObjectContext?
score:0
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.
http://code.google.com/p/dblinq2007/
Npgsql can be configured as a db provider for Entity Framework following the documentation on this Npgsql blog:
http://npgsql.com/index.php/2009/08/how-to-set-up-entity-framework-npgsql-part-1/
Source: stackoverflow.com
Related Articles
- 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