• 写一个system.data.entity的simpledatarepo,实现crudq这些功能,不需要引入entityframework,直接可以使用,用到objectset


    note:you can delete reference of entityframework when using this classes.it`s just a simple repohelper.the code below can also include a getpagedlist method when paging.
    have fun,it`s simple,just create edmx file from database.all one sentence.but when using iqueryable or transaction,you need to use context factory and develop your own methods.
    i am using it now.very simple.just like a static modelhelper orm.
    1.simpledaterepo:
    /*
     * author:iGo
     * for-free
     * last-update:2015年7月7日 
     * auth:mit
     * hope it will be useful to you
     * */
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Linq;
    using System.Linq.Expressions;
    
    
    
    namespace DBContext {
        /// <summary>
        /// static data repo,you donot need to reference entity framework
        /// </summary>
        public class SimpleDataRepo {
            public static void Add<T>(T model) {
                if (model == null) return;
                using (var context = DataContext.Context) {
                    context.AddObject(typeof(T).Name, model);
                    context.SaveChanges();
                }
            }
    
            public static void Edit<T>(T model) where T : class {
                if (model == null) return;
                using (var context = DataContext.Context) {
                    context.AddObject(model.GetType().Name, model);
                    context.ObjectStateManager.ChangeObjectState(model, EntityState.Modified);
                    context.SaveChanges();
                }
            }
            public static void EditCommand<T>(String setCondition, String whereClause) {
                if (String.IsNullOrEmpty(setCondition)) return;
                using (var context = DataContext.Context) {
                    context.ExecuteStoreCommand(String.Format("update {0} set {1} where {2}", typeof(T).Name, setCondition, whereClause));
                }
            }
    
            public static void Delete<T>(T model) where T : class {
                if (model == null) return;
                using (var context = DataContext.Context) {
                    context.AddObject(model.GetType().Name, model);
                    context.ObjectStateManager.ChangeObjectState(model, EntityState.Deleted);
                    context.SaveChanges();
                }
    
            }
    
    
            [NotUsed("not used due to linq function unsupported!")]
            private static int GetPropertyIdValueFromModel<T>(T model) {
                return (int)model.GetType().GetProperty("id").GetValue(model, null);
            }
    
    
    
            public static IList<T> GetAll<T>(Expression<Func<T, bool>> condition = null) {
                using (var context = DataContext.Context) {
                    var query = context.GetType().GetProperty(typeof(T).Name).GetValue(context, null) as IQueryable<T>;
                    return query != null ? query.ToList() : null;
                }
            }
    
            public static IList<T> GetAllCommand<T>(String whereClause = "") {
                using (var context = DataContext.Context) {
                    return context.ExecuteStoreQuery<T>(String.Format("select * from {0} {1}", typeof(T).Name,
                         String.IsNullOrEmpty(whereClause) ? "" : (" where " + whereClause))).ToList();
                }
            }
    
    
            /// <summary>
            /// Get first model that satisfies the specified condition,GetById can be implied here,ie:a=>a.Id=5
            /// </summary>
            /// <typeparam name="T"></typeparam>
            /// <param name="condition"></param>
            /// <returns></returns>
            public static T QueryFirst<T>(Expression<Func<T, bool>> condition) {
                using (var context = DataContext.Context) {
                    var query = context.GetType().GetProperty(typeof(T).Name).GetValue(context, null) as IQueryable<T>;
                    if (query == null) return default(T);
                    return query.FirstOrDefault(condition);
                }
            }
    
            public static T QueryFirstCommand<T>(String condition = "") {
                using (var context = DataContext.Context) {
                    return
                        context.ExecuteStoreQuery<T>(String.Format("select top 1 * from {0} {1}", typeof(T).Name,
                            String.IsNullOrEmpty(condition) ? "" : (" where " + condition))).FirstOrDefault();
                }
            }
    
            public static IList<T> QuerySort<T, TS>(Expression<Func<T, bool>> condition, Expression<Func<T, TS>> sortExpression = null, bool isDecending = false) {
                using (var context = DataContext.Context) {
                    var query = context.GetType().GetProperty(typeof(T).Name).GetValue(context, null) as IQueryable<T>;
                    if (query == null) return null;
                    query = query.Where(condition).Where(condition);
                    if (sortExpression != null)
                        query = isDecending ? query.OrderByDescending(sortExpression) : query.OrderBy(sortExpression);
                    return query.ToList();
                }
            }
    
            public static void DeleteByIds<T>(String ids) {
                if (String.IsNullOrEmpty(ids)) throw new ArgumentException("ids cannot be null or empty!");
                using (var context = DataContext.Context) {
                    context.ExecuteStoreCommand(String.Format("delete from {0} where id in ({1})", typeof(T).Name, ids));
                    context.SaveChanges();
                }
            }
    
    
    
            #region web paging field
    
    
            //protected virtual IPagedList<T> GetTPagedList<T, TS>(Expression<Func<T, bool>> filter = null, Expression<Func<T, TS>> orderby = null, bool isDecending = false) where T : new() {
            //    IPagedList<T> list;
            //    using (var context = DataContext.Context) {
            //        var pageIndex = Request["pageNum"] ?? "1";
            //        var pageSize = Request["numPerPage"] ?? "15";
    
            //        Expression<Func<T, bool>> condition = a => true;
            //        if (filter != null) condition = condition.And(filter);
            //        var b = context.GetType().GetProperty(typeof(T).Name).GetValue(context, null) as IQueryable<T>;
            //        if (b == null) return null;
            //        b = b.Where(condition);
            //        if (orderby != null)
            //            b = !isDecending ? b.OrderBy(orderby) : b.OrderByDescending(orderby);
            //        list = b.ToPagedList(int.Parse(pageIndex), int.Parse(pageSize));
            //        //b.Skip(int.Parse(pageSize)*(int.Parse(pageIndex) - 1)).Take(int.Parse(pageSize)).ToList();
            //    }
            //    return list;
            //}
            #endregion
    
    
        }
    }
    
     
     2.context factory:
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Entity;
    using System.Linq;
    using System.Text;
    
    namespace DBContext {
        public partial class DataContext  {
            public static GpsDataContext Context {
                get {
                    return new GpsDataContext();
                }
            }
        }
    }
    
  • 相关阅读:
    CentOS系统一键部署jdk,maven,tomcat,mysql
    使用sed在源文件上直接替换某一行的内容,只替换第一次找到的那行
    MLPerf 机器学习基准测试实战入门(一)NAVIDA-GNMT
    SpringBoot Controller接收参数的几种常用方式(转)
    使用延时队列DelayQueue
    Oracle、MySql、SQLServer 数据分页查询(转)
    SqlServer收缩日志
    防火墙升级导致产环境服务中止20小时的问题
    NFS相关
    jquery.validate不使用submit提交,而是使用button按钮提交
  • 原文地址:https://www.cnblogs.com/hualiu0/p/4627726.html
Copyright © 2020-2023  润新知