C# (CSharp) VL.Common.Core.ORM SelectBuilder Examples

Example #1

 /// <summary>
 /// 新增条件项
 /// </summary>
 public void Add(PDMDbProperty property, SelectBuilder subSelect, LocateType operatorType, string nickName = null)
 {
     Wheres.Add(new ComponentValueOfWhere(property, subSelect, operatorType, nickName));
 }

Example #2

 /// <summary>
 /// 未查询到数据时返回 null
 /// </summary>
 public abstract DateTime?SelectAsDateTime <T>(SelectBuilder selectBuilder) where T : VLModel_DB, new();

Example #3

 /// <summary>
 /// 未查询到数据时返回 null
 /// </summary>
 public abstract DbDataReader SelectAsDataReader <T>(SelectBuilder selectBuilder) where T : VLModel_DB, new();

Example #4

 /// <summary>
 /// 未查询到数据时返回 null
 /// </summary>
 public abstract string SelectAsString <T>(SelectBuilder selectBuilder) where T : VLModel_DB, new();

Example #5

 /// <summary>
 /// 未查询到数据时返回 null
 /// </summary>
 public abstract List <string> SelectAsStrings <T>(SelectBuilder selectBuilder) where T : VLModel_DB, new();

Example #6

 /// <summary>
 /// 未查询到数据时返回 null
 /// </summary>
 public abstract long?SelectAsLong <T>(SelectBuilder selectBuilder) where T : VLModel_DB, new();

Example #7

 /// <summary>
 /// 未查询到数据时返回 null
 /// </summary>
 public abstract Guid?SelectAsGuid <T>(SelectBuilder selectBuilder) where T : VLModel_DB, new();

Example #8

 /// <summary>
 /// 未查询到数据时返回 null
 /// </summary>
 public abstract short?SelectAsShort <T>(SelectBuilder selectBuilder) where T : VLModel_DB, new();

Example #9

 /// <summary>
 /// 未查询到数据时返回 null
 /// </summary>
 public abstract int?SelectAsInt <T>(SelectBuilder selectBuilder) where T : VLModel_DB, new();

Example #10

 /// <summary>
 /// 未查询到数据时返回 New List()
 /// 单个SelectBuilder查询一组数据
 /// </summary>
 public abstract List <T> SelectAll <T>(SelectBuilder selectBuilder) where T : VLModel_DB, new();

Example #11

 ///// <summary>
 ///// 未查询到数据时返回 New List()
 ///// </summary>
 //public abstract List<T> SelectAll<T>(DbQueryBuilder queryBuilder) where T : IPDMTBase, new();
 /// <summary>
 /// 未查询到数据时返回 null
 /// </summary>
 public abstract bool?SelectAsBool <T>(SelectBuilder selectBuilder) where T : VLModel_DB, new();

Example #12

 /// <summary>
 /// 未查询到数据时返回 null
 /// </summary>
 public abstract T Select <T>(SelectBuilder selectBuilder) where T : VLModel_DB, new();

Example #13

File: SQLiteQueryOperator.cs Project: vlong638/VL.Common

        /// <summary>
        /// 失败返回 new List<T>()
        /// </summary>
        public override List <T> SelectAll <T>(DbQueryBuilder queryBuilder)
        {
            SelectBuilder selectBuilder = queryBuilder.SelectBuilders.First();

            return(SelectAll <T>(selectBuilder));
        }

Example #14

File: SQLiteQueryOperator.cs Project: vlong638/VL.Common

        /// <summary>
        /// 失败返回null
        /// </summary>
        public override T Select <T>(DbQueryBuilder queryBuilder)
        {
            SelectBuilder selectBuilder = queryBuilder.SelectBuilders.FirstOrDefault();

            return(Select <T>(selectBuilder));
        }

Example #15

 public override DbDataReader SelectAsDataReader <T>(SelectBuilder selectBuilder)
 {
     throw new NotImplementedException();
 }

Example #16

 public override List <string> SelectAsStrings <T>(SelectBuilder selectBuilder)
 {
     throw new NotImplementedException();
 }