[Table("CLASS1", Schema = "public")]
public class Class1
{
public int Class1Id { get; set; }
public string Name1 { get; set; }
}
[Table("CLASS2", Schema = "public")]
public class Class2
{
public int Class2Id { get; set; }
public string Name2 { get; set; }
public int Class1Id { get; set; }
public virtual Class1 c1 { get; set; }
我定义了一个DatabaseContext:
public sealed class DatabaseContext : DbContext
{
private static readonly DatabaseContext instance = new DatabaseContext();
public static DatabaseContext Instance
{
get
{
return instance;
}
}
private DatabaseContext()
: base("maconnexion")
{
Database.SetInitializer<DatabaseContext>(null);
}
public DbSet<Class1> table1{ get; set; }
public DbSet<Class2> table2{ get; set; }
}
我已经将这些行添加到了我的App.config文件中。
<DbProviderFactories>
<add name="Npgsql Data Provider" invariant="Npgsql" description="Data Provider for PostgreSQL" type="Npgsql.NpgsqlFactory, Npgsql" />
</DbProviderFactories>
<connectionStrings>
<add name="maconnexion"
connectionString="Server=127.0.0.1;Port=5432;Database=DB_Ticketing;UserId=postgres;Password=slots2013;" providerName="Npgsql" />
</connectionStrings>
我已经在PostgreSQL中创建了名为DB_Ticketing的数据库。但是当我执行代码时,表table1和table2没有被添加到我的数据库中。