.net core dapper (1)

0.0  总是要追求一点什么,那就从最简单的事情开始做起吧,先写一句话给自己

　　你站在桥上看风景，看风景的人在楼上看你。

　　明月装饰了你的窗子，你装饰了别人的梦。

　因为是随笔所以很随意... ...

 1.给自己的项目取一个名字，使用 vs2019 , .net core 3.0

  引用 dapper

2.然后构建一个类

    public class Customer
    {
        public int CustomerID { get; set; }
        public string CustomerName { get; set; }public string Address { get; set; }
        public string City { get; set; }
        public string PostalCode { get; set; }
        public string Country { get; set; }
    }

3.数据库脚本

USE [Demo]
GO
/****** Object:  Table [dbo].[Customer]    Script Date: 2019/11/27 14:50:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Customer](
    [CustomerID] [int] IDENTITY(1,1) NOT NULL,
    [CustomerName] [nvarchar](200) NULL,
    [Address] [nvarchar](200) NULL,
    [City] [nvarchar](200) NULL,
    [PostalCode] [nvarchar](200) NULL,
    [Country] [nvarchar](200) NULL,
 CONSTRAINT [PK_Customer1] PRIMARY KEY CLUSTERED 
(
    [CustomerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

4. 下面就开始使用dapper 了

using Dapper;
using System;
using System.Data.SqlClient;


namespace DotNetCoreDapper
{
    public class Program
    {
        public static void Main(string[] args)
        {
            var connectionString = "Server=.;Database=Demo;User Id=sa;Password = keno;";

            //use package System.Data.SqlClient
            using (var connection = new SqlConnection(connectionString))
            {
                var customer = connection.QueryFirst<Customer>("select * from [dbo].[Customer] where customerid=1");

                Console.WriteLine("id: " + customer.CustomerID + " CustomerName:  " + customer.CustomerName + " ContactName: " + customer.ContactName + " Address: " + customer.Address + " City: " + customer.City + " PostalCode: " + customer.PostalCode);
            }


            Console.ReadKey();
        }
    }
}

5.最后是一个简单的结果

到此一个简答的demo 已经完成明天见......