C# (CSharp) InDapper Examples

Example #1

File: BoardDAO.cs Project: HaoruSung/Backend_Structure

        public List <Board> GetAll(InDapper item)
        {
            var result = _connString.Query <Board>(item.SQL, item.Param).ToList();

            //關閉連線字串
            _connString.Dispose();
            return(result);
        }

Example #2

File: DapperDMO.cs Project: HaoruSung/Backend_Structure

        public InDapper DAPPER(string SQL, object Param)
        {
            InDapper Dapper = new InDapper {
                SQL = SQL, Param = Param
            };

            return(Dapper);
        }

Example #3

File: BoardBLO.cs Project: HaoruSung/Backend_Structure

        public List <Board> GetAll()
        {
            string SQL = @"SELECT * FROM Board";

            object Param = new { };

            InDapper Dapper = iDapperDMO.DAPPER(SQL.ToString(), Param);

            return(iBoardDAO.GetAll(Dapper));
        }