CODEWITHSUNDEEP
c#databaseentity-framework
Jack
Jack

Reputation: 53

Windows Forms Entity Framework database solution

I'm currently creating a Windows Forms Application. I require a local database and have opted to use the code-first approach with the Entity Framework in order to build it. I have not worked with a database with C# before and I am struggling to set one up with the entity framework.

I currently have two classes: Ingredient, and Recipe. Both contain POCOs. From what I can gather, the entity framework should create a local database, making these classes tables. However a database is not being created.

Could anyone shed some light on what I am doing wrong? I apologise if my question is too broad.

Thank you for your time.

Ingredient Class:

    public class Ingredient
    {
        public int IngredientID { get; set; }
        public string IngredientName { get; set; }
        public string IngredientDescription { get; set; }
        public virtual Recipe Recipe { get; set; }
    }

Recipe Class:

public class Recipe
{
    public int RecipeID { get; set; }
    public string RecipeName { get; set; }
    public string RecpeDescription { get; set; }

    public virtual List<Ingredient> Ingredients { get; set; }

    public Recipe()
    {
        this.Ingredients = new List<Ingredient>();
    }
}

DbContext Class

class RecipeContext : DbContext
{
        public DbSet<Recipe> Recipes { get; set; }
        public DbSet<Ingredient> Ingredients { get; set; }
}

Upvotes: 0

Views: 2608

Answers (2)

Wiktor Zychla
Wiktor Zychla

Reputation: 48230

You need a connection string and one of database initializers that create a database if it doesn't exists.

public class RecipeContext : DbContext
{ 
     // the default constructor
     public RecipeContext()  : base() { }

     // this one lets you pass a connection string
     public RecipeContext( string connectionString ) : base( connectionString ) { }

     ...

Then, at the very beginning of your app set the initializer:

  Database.SetInitializer<RecipeContext>(new CreateDatabaseIfNotExists<RecipeContext>());

And finally, just try to connect to your database, with a valid connection string:

 // local database connection string has to point to the local db server
 string cs = "server=(localdb)/v11.0;database=anewdatabase;integrated security=true";

 using ( var ctx = new RecipeContext( cs ) )
 {
    // any database operation will first trigger the initializer 
    // which initializes the database once per app domain

    // in case of the CreateDatabaseIfNotExists
    // a new, empty database matching your model is created
 }

Upvotes: 0

Ab&#237;lio Esteves
Ab&#237;lio Esteves

Reputation: 187

EF is quite flexible with these things. Get acquainted with the Nuget Package Manager Console (it is from there that you'll interact with Entity Framework DB generation routines). Following these steps you should be good to go:

  1. Add a connection string to your start up application. An example is the following:

    <configuration> <connectionStrings> <add name="Local" connectionString= "Data Source=.;Initial Catalog=NAME;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings> </configuration>

  2. Create a Context class that inherits DbContex;

  3. Add the following constructor to you Context class:

    public Context() : base("Local") {}

  4. Add DbSet properties to your Context class (so EF can track them down);

  5. Go to the Package Manager Console, select the project that holds the DbContext class, and type the following:

    Enable-Migrations

  6. On the same console type:

    Add-Migration Initial

  7. Again in the same console:

    Update-Database

This should create a database with the name you have set in the connection string.

Hope this helps!

Cheers!

Upvotes: 3

Related Questions