>>>> public interface IContext : IDisposable >>>> { >>>> IDbSet<T> Set<T>() where T : class; >>>> int SaveChanges(); >>>> void SetModified(object entity); >>>> void SetAdd(object entity); >>>> void SetDeleted(object entity); >>>> void ExecuteSqlCommand(string sql); >>>> EntityState GetEntityState(object entity); >>>> bool IsLoaded(object entity, string navigationPropertyName); >>>> void Load(object entity, string navigationPropertyName); >>>> DbPropertyValues GetOriginalValues(object entity); >>>> DbPropertyValues GetCurrentValues(object entity); >>>> void EnsurePaddedPrimaryKey<T>(T entity) where T : class; >>>> ObjectContext CoreContext { get; } >>>> }>>>>
>>>> var query = this._siriusContext.Max4Sale.Where(m4s => m4s.Type == max4sale.Type);>>>>
>>>> public interface ISiriusSqlContext : IContext >>>> { >>>> IDbSet<AccActv> AccActv { get; set; } // acc_actv >>>> IDbSet<Access> Access { get; set; } // access >>>> etc. for all other tables/views >>>> } >>>>>>>
>>namespace SysManager.Repository >>{ >> public abstract class RepositoryBaseWithList<T, TList> : IRepositoryWithList<T, TList> >> where T : class where TList: class >> { >> protected readonly ISiriusSqlContext _siriusContext; >> >> protected readonly IDbSet<T> _dbSet; >> protected readonly IDbSet<TList> _dbSetList; >> private readonly IExceptionParser _exceptionParser; >>etc.>
public class Max4SaleRepository : RepositoryBaseWithList<Max4Sale, Max4SaleList>, IMax4SaleRepository { public Max4SaleRepository(ISiriusSqlContext context) : base(context) { }