Gettings started with EF (SqlServerCe)

Question

I am creating an application in WPF, and I want connect to a database using SQL Server Compact 4.0.

I add data base to project. And using NuGet I added

• System.Data.SqlServerCe
• System.Data.SqlServerCe.Entity

In my app.config a connection string was added:

 <connectionStrings>
    <add name="Biblionerzy.Properties.Settings.Database1ConnectionString"
      connectionString="Data Source=|DataDirectory|\Database1.sdf"
      providerName="Microsoft.SqlServerCe.Client.4.0" />
  </connectionStrings>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlCeConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="System.Data.SqlServerCe.4.0" />
      </parameters>
    </defaultConnectionFactory>
  </entityFramework>

I created a simple class:

namespace Biblionerzy
{
   public class model
    {
        [Key] 
        public int Id { get; set; }
        public string Pytanie { get; set; }
        public string A { get; set; }
        public string B { get; set; }
        public string C { get; set; }
        public string D { get; set; }
        public string Prawidlowa_odp { get; set; }
        public int Stawka { get; set; } 
    }

   public class PytaniaModel : DbContext
   {
       public DbSet<model> Modele { get; set; }
   }
}

And now, how can I add anything into database?

Answer 1

I think you are just trying to get started with EF code first (if not, i'll remove the answer).

by the looks of your question you got everything setup.

You might need to add a [Key] attribute, I can't understand what is below so I just added a property Id which I gave the [Key] attribute.

   public class model
    {
        [Key]
        public int Id {get;set;}
        public string Pytanie { get; set; }
        public string A { get; set; }
        public string B { get; set; }
        public string C { get; set; }
        public string D { get; set; }
        public string Prawidlowa_odp { get; set; }
        public int Stawka { get; set; } 
    }

   public class PytaniaModel : DbContext
   {
       public DbSet<model> Modele { get; set; }
   }

Just instantiate an object of the class and use it...

   var dbContext = new PytaniaModel();
   dbContext.Modele.Add(new Model());
   dbContext.SaveChanges();

And that's it, check your database and verify that the database is created and you stored your first row in the table.