Dapper试用简例

using Dapper;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebApplication1
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        /// <summary>
        /// 实体化一个对象
        /// </summary>
        public class Area
        {
            public int AreaId { get; set; }
            public string AreaName { get; set; }
            public int AreaPid { get; set; }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                return;
            }
            ConnSql();
            //ExcuteSql(new Area
            //{
            //    AreaName = "河南省"
            //    ,
            //    AreaPid = 0
            //});

        }
        /// <summary>
        /// 连接数据库
        /// </summary>
        /// <returns></returns>
        private SqlConnection OpenConnection()
        {
            string connectionString = ConfigurationManager.ConnectionStrings["Sql"].ConnectionString;
            SqlConnection connection = new SqlConnection(connectionString);
            connection.Open();
            return connection;
        }
        /// <summary>
        /// 查询操作
        /// </summary>
        private void ConnSql()
        {
            using (IDbConnection connection = OpenConnection())
            {
                string sql = @"select AreaId,AreaName from TblArea  ";
                var parameter = new DynamicParameters();
                parameter.Add("@AreaName", null, null, null);
                IEnumerable<Area> links = connection.Query<Area>(sql, parameter);
                GridView1.DataSource = links;
                GridView1.DataBind();
            }
        }
        /// <summary>
        /// 执行性语句
        /// </summary>
        /// <param name="AreaMode"></param>
        private void ExcuteSql(Area AreaMode)
        {
            using (IDbConnection connection = OpenConnection())
            {
                string sql = @"insert into TblArea (AreaName,AreaPid) values(@AreaName,@AreaPid) ";
                var parament = new DynamicParameters();
                parament.Add("@AreaName", AreaMode.AreaName, null, null, null);
                parament.Add("@AreaPid", AreaMode.AreaPid, null, null, null);
                int links = connection.Execute(sql, parament);
                if (links > 0)
                {
                    Response.Write(links.ToString());
                }
            }
        }
    }
}