How to use LINQ for standard C# application with local database file?

Question

I'm used to work with ASP.NET and I have no problems there, but now I need to create a C# Console application and something is wrong.

I create console application
Add new item to project (Local database)
Fill in some basic data (id, name)

But when I create LINQ to SQL Class and drag my table to it like I do in ASP.NET I get error

The selected objects use an unsupported data provider

What am I doing wrong here, how can I make my work with databases using C# Console/Windows application as fast and easy as with ASP.NET applications?

How are you connecting to your database? Where is your connection string defined? Visual Studio will create a web.config file for ASP.NET applications. You will need to add an app.config file or hard code the connection string someplace. — Jeff Reddy
– Jeff Reddy, Commented Jan 6, 2012 at 17:36

Darwyn · Accepted Answer · 2012-01-06 17:45:11Z

2

The database driver / provider needs to allow for the usage of linq. If you are using a simple sqlite db, I would recommend using the DBLinq provider.

If you are using Microsoft's lightweight database (Sql Compact) then I believe this article maybe helpful.

answered Jan 6, 2012 at 17:45

Darwyn

4,8143 gold badges28 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Stan Over a year ago

Is the SqlMetal goes by default with Visual Studio 2010 installation and I won't have problems using it on different computer that has same compiler installed as me?

Darwyn Over a year ago

I believe sqlmetal is part of the windows sdk ... I think it gets installed by default with VS 2010. If it's missing you can download the sdk here (msdn.microsoft.com/en-us/windows/bb980924.aspx) or add the feature with the VS2010 installer.

Manas · Accepted Answer · 2012-01-06 17:52:21Z

0

The Object Relational Designer (O/R Designer) supports only the .NET Framework Data Provider for SQL Server ( System.Data.SqlClient).

Where as sdf local DB is a Compact Database. SQL Server Compact Edition (System.Data.SqlServerCe) is not supported by O/R Designer.

Instead you can create a db in SQLExpress and connect to Designer

edited Jan 6, 2012 at 17:52

answered Jan 6, 2012 at 17:44

Manas

2,54221 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to use LINQ for standard C# application with local database file?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related