IObHelper<Model> dal = ObHelper.Create<Model>(connectionString, providerName);

IList<Model> list = dal.Where(o => o.Name.Contains("a")).GroupBy(o => o.Name).Select(o => new {Id = o.Max(k => k.Id)}).OrderBy(o => o.Name).ToList();

dal.Add(new Model(){Id = 1, Name="abc"});

dal.Update(new Model(){Name=""}, o => o.Id == 1);

dal.Delete(o => o.Id == 1);

ObJoin

Replace
SubString
IndexOf
ToInt16
ToInt32
ToInt64
ToSingle
ToDouble
ToDecimal
ToDateTime
ToString

ObException.CurrentExeSql

IObHelper<TM, TT> dal = ObHelper.Create<TM, TT>(connectionString, providerName);

IList<TM> list = dal.Where(o => o.Name.Like("a")).GroupBy(o => o.Name).Select(o => new {Id = o.Max(k => k.Id)}).OrderBy(o => o.Name).ToList();

dal.Delete(o => o.Id == 1);

dal.Update(new TM(){Name=""}, o => o.Id == 1);

IList<TM> list = dal.GroupBy(o => o.Name).Select(o => new {Id = o.Max(k => k.Custom("dbo.test", t => t.Id))}).ToList();

IObHelper<TM, TT> dal = ObHelper.Create<TM, TT>(connectionString, providerName);
TM m = dal.SqlText(sqlText, params).ToModel();
IList<TM> list = dal.SqlText(sqlText, params).ToList();

例：更新数据代码

/// <summary>
/// 部门模型类
/// </summary>
[ObModel(Name = "Departments")]
public class DepartmentInfo : ObModelBase
{
        /// <summary>
        /// 部门编号
        /// </summary>	
        [ObConstraint(ObConstraint.PrimaryKey)]
        [ObProperty(Name = "ID", Length = 4, Nullable = false)]
        public virtual int Id { get; set; }

        /// <summary>
        /// 门部名称
        /// </summary>	
        [ObProperty(Name = "Name", Length = 50, Nullable = false)]
        public virtual string Name { get; set; }
}

/// <summary>
/// 部门条件类
/// </summary>
public class DepartmentBase : ObTermBase
{
        public Department() : base(typeof(DepartmentInfo))
        { }

        public Department(ObTermBase parent, string rename) : base(typeof(DepartmentInfo), parent, rename)
        { }

        /// <summary>
        /// 部门编号
        /// </summary>		
        public virtual ObProperty Id { get; }

        /// <summary>
        /// 部门名称
        /// </summary>		
        public virtual ObProperty Name { get; }
}

DepartmentInfo m = new DepartmentInfo().Of();
或
DepartmentInfo m = ObModel.Create<DepartmentInfo>();
或
DepartmentInfo m = (DepartmentInfo)ObModel.Create(typeof(DepartmentInfo));

m.Name = "Name";

Department term = new Department().Of();
或
Department term = ObModel.Create<Department>(new Department());
或
Department term = (Department)ObModel.Create(typeof(Department), new Department());

IObHelper<DepartmentInfo, Department> dal = term.Helper<DepartmentInfo, Department>(connectionString, providerName);
或
IObHelper<DepartmentInfo, Department> dal = ObHelper.Create<DepartmentInfo, Department>(term, connectionString, providerName);

dal.Update(m, o => o.Id == 1);