C# EF Code first - create database and add data

Question

I want to create database and add some data. I added EF and I want to use code first. I have these classes:

public class Question
{
    public bool Sort { get; set; }
    public int QuestionID { get; set; }
    public int Level { get; set; }
    public string Description { get; set; }
    public string Answer1 { get; set; }
    public string Answer2 { get; set; }
    public string Answer3 { get; set; }
    public string Answer4 { get; set; }
    public string RightAnswer { get; set; }
    public bool Show { get; set; }
}

public class QuestionDb : DbContext
{
    public DbSet<Question> Questions { get; set; }
}

This is my connection string:

<add name="ConvertCSVtoSQL.QuestionDb" connectionString="Data Source=|DataDirectory|ConvertCSVtoSQL.QuestionDb.sdf"
      providerName="System.Data.SqlServerCe.4.0" />

Now I am creating database like this:

using (var db = new QuestionDb())
        {

            foreach (var question in questions)
            {
                db.Questions.Add(question);
            }
            db.SaveChanges();
        }

It creates database but if I have some data in questions which I want to add I get error:

The Entity Framework provider type 'System.Data.Entity.SqlServerCompact.SqlCeProviderServices, EntityFramework.SqlServerCompact, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' for the 'System.Data.SqlServerCe.4.0' ADO.NET provider could not be loaded. Make sure the provider assembly is available to the running application. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information.

I tried to add some initializers but it didn't help:

Database.DefaultConnectionFactory = new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0",@"C:\Path\To\",@"Data Source=C:\Path\To\DbFile.sdf");
Database.SetInitializer(new CreateDatabaseIfNotExists<QuestionDb>());

So where is problem?

Proberly your connectionstring that makes the error. Check "mvc music store" and see how he did. — thatsIT
– thatsIT, Commented Dec 21, 2012 at 8:45
So did you visit the link in the exception message? What you tried does not seem to be inspired by that. — Gert Arnold
– Gert Arnold, Commented Dec 21, 2012 at 18:52
Thanks, I thought I don't find any useful information but I looked there and I added EntityFramework.SqlServerCompact package by Nuget and It helps. — Libor Zapletal
– Libor Zapletal, Commented Dec 22, 2012 at 17:38

Libor Zapletal · Accepted Answer · 2012-12-22 17:39:44Z

2

I looked at link in exception, add nuget package EntityFramework.SqlServerCompact to my solution and it helps.

answered Dec 22, 2012 at 17:39

Libor Zapletal

14.2k21 gold badges100 silver badges192 bronze badges

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

Comments

Karthika Subramanian · Accepted Answer · 2012-12-21 09:11:39Z

1

Please check the connection string's provider name...

http://weblogs.asp.net/scottgu/archive/2010/12/08/announcing-entity-framework-code-first-ctp5-release.aspx

Hope you may find this useful

Database.DefaultConnectionFactory = new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0",@"C:\\Path\To\\",@"Data Source=C:\\Path\\To\\DbFile.sdf");
Database.SetInitializer(new CreateDatabaseIfNotExists<QuestionDb>());

edited Dec 21, 2012 at 9:11

answered Dec 21, 2012 at 8:49

Karthika Subramanian

3461 gold badge2 silver badges16 bronze badges

2 Comments

Libor Zapletal Over a year ago

When I change provider name to: System.Data.SqlClient I get this error:

An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.

Karthika Subramanian Over a year ago

Please try this way...

Database.DefaultConnectionFactory = new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0",@"C:\\Path\\To\\",@"Data Source=C:\\Path\To\\DbFile.sdf"); Database.SetInitializer(new CreateDatabaseIfNotExists<QuestionDb>());

mahesh reddy · Accepted Answer · 2013-02-19 22:04:19Z

1

Running following Command in VS Package manager Console resolved my issue:

Install-Package EntityFramework.SqlServerCompact -Pre

answered Feb 19, 2013 at 22:04

mahesh reddy

3773 silver badges10 bronze badges

Collectives™ on Stack Overflow

C# EF Code first - create database and add data

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related