Code First Entity Framework not creating tables in the database

Question

0.00/5 (No votes)

See more:

I just created a simple class library using Code First Entity Framework 4.1.

The db connection is in the console applcations app.config and the name of the connectionstring is "default".
So i initialized the DbContext like this -

C#

public class EmployeeContext : DbContext
    {
       public EmployeeContext() : base("name=default") { }
        public List<employee> Employees { get; set; }
    }

I have referenced the Class Library in the console application. Then just try to add one employee.

C#

class Program
    {
        static void Main(string[] args)
        {
            createEmp();
        }
 
        static void createEmp()
        {
            var obj = new EmployeeContext();
            Employee emp = new Employee();
            emp.ID = 1;
            emp.Name = "Test";
            obj.SaveChanges();
        }
    }

There is no error but the tables are not created in database.

When I look into the employeecontext, I see this exception -
ServerVersion '(((System.Data.Entity.DataContext)(obj)).Database.Connection).ServerVersion' threw an exception of type 'System.InvalidOperationException' string {System.InvalidOperationException}
The connection is closed.

This is my first hands on with code first entity framework.

Anyone has any idea of what is wrong?

Posted 13-Dec-11 3:38am

Kochadayan

Updated 13-Dec-11 4:06am

RaisKazi

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Julie Lerman · Accepted Answer · 2011-12-13T04:42:00

There are two big problems with your code. I highly recommend that you watch or read some intro material on using Code First and EF. On msdn (msdn.com/data/ef) you can find some short intro videos on code first.

Problem #1: in the dbcontext, Employees must be a DbSet<Employee> for EF to be able to interact with the employee data.

Problem #2:Code First will initialize the database the first time EF needs to access it. But there will be no db access because you've created the employee but the obj (context) is unaware of it.

Before obj.SaveChanges, add the new employee so that the obj is aware of it with:

obj.Employees.Add(emp);