public partial class ClientInfoForm : ChildFormTemplate, IViewCustomerInfo
    {
        private bool _valid_flag = true;
        private CustomerInfoPresenter presenter;
//..........

void CustomerInfoForm_Load(object sender, EventArgs e)
        {
            /////..............

            presenter = new CustomerInfoPresenter(this);
//......
}

 public interface ICustomerInfoPresenter
    {
        DataTable SendTypeSource();
        IViewCustomerInfo View {get;set;}
    }
    public class CustomerInfoPresenter : ICustomerInfoPresenter
    {
        private IViewCustomerInfo _view;
        private CustomerInfoModel _model;

        public CustomerInfoPresenter()
        {
 
        }

        public CustomerInfoPresenter(IViewCustomerInfo view)
        {
            _view = view;
            _view.CustomertFilterChanged += new EventHandler<EventArgs>(_view_CustomertFilterChanged);
            
            _view.Loading += new EventHandler<EventArgs>(_view_Loading);
            
        }

        public IViewCustomerInfo View { 
            get {
                return _view;
            }
            set
            {
            	_view = value;
            }
        }

 void _view_CustomertFilterChanged(object sender, EventArgs e)
        {
            Model.LoadCustomer(_view.SelectedCustomer??Guid.Empty);
            FillControls();
        }

    public class CustomerInfoModel
    {
        public CustomerInfoModel()
        {
            CurrentCustomer = new Direction();
        }
        internal void LoadCustomer(Guid ID)
        { 
            Model = new DALCustomerInfoModel(ConnectionStringState.GetEntityConnectionString());
            this.CurrentCustomer = Model.GetItem(ID);
        }

        bool CustomerChanged {get;set;}
        internal Direction CurrentCustomer { get; set; }

       DALCustomerInfoModel Model { get; set; }

        public bool SaveCustomer()
        {
            if (Model == null) Model = new DALCustomerInfoModel(ConnectionStringState.GetEntityConnectionString());
            return Model.SaveItem(CurrentCustomer);
           
        }

public class DALCustomerInfoModel
    {
        CustomerInfoEntities dbcontext;
        string _connectionstring;

        public DALCustomerInfoModel(string connectionstring)
        {
            _connectionstring = connectionstring;
            dbcontext = new CustomerInfoEntities();
            (dbcontext.Database.Connection as SqlConnection).ConnectionString = _connectionstring;        
        }
        public Direction GetItem(Guid id)
        {
            try
            {
                dbcontext.Direction.SqlQuery(string.Format("nsp_get_Direction '{0}'", id)).ToList();
                return dbcontext.Direction.Local.FirstOrDefault();
            }
            catch 
            {
                return null;
            }

        }
        public bool SaveItem(Direction item)
        {
            try
            {
                if (item == null) return false;
                if (item.IDDirection == Guid.Empty)
                    dbcontext.Entry<Direction>(item).State = EntityState.Added;
                else
                {
                    dbcontext.Entry<Direction>(item).State = EntityState.Modified;
                }
                dbcontext.SaveChanges();
                return true;
            }
            catch (System.Data.Entity.Infrastructure.DbUpdateException ex)
            {
                if (ex.InnerException != null)
                    if (ex.InnerException.InnerException!=null)
                        UserMessanger.WarningUser(ex.InnerException.InnerException.Message);
                    else
                        UserMessanger.WarningUser(ex.InnerException.Message);
                else
                    UserMessanger.WarningUser(ex.Message);
                return false;
            }
            catch (DbEntityValidationException ex)
            {
                if (ex.InnerException != null)
                    if (ex.InnerException.InnerException != null)
                        UserMessanger.WarningUser(ex.InnerException.InnerException.Message);
                    else
                        UserMessanger.WarningUser(ex.InnerException.Message);
                else
                    UserMessanger.WarningUser(ex.Message);
                return false;
            }
            catch (Exception ex)
            {
                if (ex.InnerException != null)
                    if (ex.InnerException.InnerException != null)
                        UserMessanger.WarningUser(ex.InnerException.InnerException.Message);
                    else
                        UserMessanger.WarningUser(ex.InnerException.Message);
                else
                    UserMessanger.WarningUser(ex.Message);
                return false;
            }
        }
    }

SQL (PL/sql) хранится в базе.И модель строится динамически.
select * from goods Товары
Одежда
Alter table goods add articul varchar2(30);
select *,articul from goods

public class BaseModelFactory<TEntity, TContext>
        where TEntity : class,IEntry, new()
        where TContext : DbContext, new()
    {

public class BaseDictionaryPresenter<TEntity, TContext> : BasePresenter, IDisposable
        where TEntity : class, IEntry, new()
        where TContext : DbContext, new()

public void Reload()
        {
            if (_presenter != null)
                _presenter = null;
            _presenter = new BaseDictionaryPresenter<DocTemplates, RMEntities>(this);
        }