Click here to Skip to main content
15,889,281 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
Hey!

I've created a DB with code first EF and later deleted the DB. Now again I want to create, but when i run project the DB is not created. I think there might be a problem with the settings. What do I need add in settings. here's my code:

C#
public class EFDbContext : DbContext
    {
        public DbSet<Advert> Adverts { get; set; }
        public DbSet<Kind> Kinds { get; set; }
        public DbSet<Age> Ages { get; set; }
        public DbSet<Castration> Castrations { get; set; }
        public DbSet<Coloring> Colorings { get; set; }
        public DbSet<Color> Colors { get; set; }
        public DbSet<Hair> Hair { get; set; }
        public DbSet<Pet> Pets { get; set; }
        public DbSet<Sex> Sexes { get; set; }
        
    }


XML
<connectionStrings>
    <add name="EFDbContext" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=SearchPets;Integrated Security=True"
          providerName="System.Data.SqlClient"/>
  </connectionStrings>


Thanks in advance

P.S. Sorry for my bad english
Posted
Updated 2-Feb-13 19:14pm
v2
Comments
sjelen 1-Feb-13 9:08am    
check if any errors are reported by sql server.
Since you use integrated security, it's possible that account you're running from does not have privilege to create database.

1 solution

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900