1.web.config文件
备注:如果连接的是同一个数据库源,两个连接指向是一样的
2.在EntityFramework项目中EntityFramework文件夹添加一个DbContext文件,例如BusinessDbContext
完整的代码(注意项目的命名空间)
using Abp.EntityFramework;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Teamax.GovApproval.MatterTypes;
namespace Teamax.GovApproval.EntityFramework
{
public class BusinessDbContext : AbpDbContext
{
public IDbSet MatterType { get; set; }
public BusinessDbContext() : base(“OracleBusiness”)
{
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.HasDefaultSchema("LS_GOVAPPROVAL");
}
}
}
3.在EntityFramework项目中EntityFramework文件夹下Repositories添加一个Repository文件,例如BusinessRepository
完整的代码(注意项目的命名空间)
using Abp.Domain.Entities;
using Abp.EntityFramework;
using Abp.EntityFramework.Repositories;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Teamax.GovApproval.EntityFramework.Repositories
{
public class BusinessRepository<TEntity, TPrimaryKey> : EfRepositoryBase<BusinessDbContext, TEntity, TPrimaryKey>
where TEntity : class, IEntity
{
protected BusinessRepository(IDbContextProvider dbContextProvider)
: base(dbContextProvider) {
}
//add common methods for all repositories
}
public abstract class BusinessRepository<TEntity> : BusinessRepository<TEntity, int>
where TEntity : class, IEntity<int>
{
protected BusinessRepository(IDbContextProvider<BusinessDbContext> dbContextProvider)
: base(dbContextProvider)
{
}
//do not add any method here, add to the class above (since this inherits it)
}
}
4.启用迁移(指定迁移配置文件的位置)
Enable-Migrations -ContextTypeName BusinessDbContext -MigrationsDirectory Migrations\BusinessDbContext
5.添加迁移(需要指定配置文件)
Add-Migration -ConfigurationTypeName Teamax.GovApproval.Migrations.BusinessDbContext.Configuration “InitialDatabaseCreation”
6.更新数据库(需要指定配置文件)
Update-Database -ConfigurationTypeName Teamax.GovApproval.Migrations.BusinessDbContext.Configuration