using Microsoft.Data.SqlClient;
using System.Xml;


namespace Fountain.WinConsole.OtherDemo
{
    internal class Program
    {
        static void Main(string[] args)
        {
            // 創(chuàng)建 Connection 對(duì)象
            using (SqlConnection sqlConnection = new SqlConnection())
            {
                // 通過 ConnectionString 屬性連接數(shù)據(jù)庫
                sqlConnection.ConnectionString = "server=127.0.0.1,1433;Enlist=true;Pooling=true; uid=sa;pwd=sa123456;connection Timeout=30;database=CRMS;Max Pool Size=600";
                // 創(chuàng)建一個(gè) SqlCommand 對(duì)象
                SqlCommand sqlCommand = sqlConnection.CreateCommand();
                // 命令的類型為Text
                sqlCommand.CommandType = System.Data.CommandType.Text;
                // 執(zhí)行命令SQL語句
                sqlCommand.CommandText = "select * from user";
                // 執(zhí)行命令返回 DataReader
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                // 輸出標(biāo)題
                Console.WriteLine($"|{"編號(hào)",-20}|{"名稱",20}|");
                while (sqlDataReader.Read())
                {
                    // 輸出行結(jié)果
                    Console.WriteLine($"|{sqlDataReader["Code"],-20}|{sqlDataReader["Name"],20}|");
                }
            }
        }
    }
}

using Microsoft.EntityFrameworkCore;
using System.Xml;


namespace Fountain.WinConsole.OtherDemo
{
    internal class Program
    {
        static void Main(string[] args)
        {
            using (var context = new UserDbContext())
            {
                var entity = new UserEntity { Name = "admin" };
                context.UserEntities.Add(entity);
                context.SaveChanges();
            }
        }
    }
    /// <summary>
    /// 用戶實(shí)體
    /// </summary>
    public class UserEntity
    {
        /// <summary>
        /// 編碼
        /// </summary>
        public int Code { get; set; }
        /// <summary>
        /// 名稱
        /// </summary>
        public string Name { get; set; }=string.Empty;
    }
    /// <summary>
    /// 
    /// </summary>    
    public class UserDbContext : DbContext
    {
        public DbSet<UserEntity> UserEntities { get; set; }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="options"></param>
        protected override void OnConfiguring(DbContextOptionsBuilder options)
        {
            string connectionString = "Server=127.0.0.1;Database=CRMS;User Id=sa;Password=sa123456;";
            options.UseSqlServer(connectionString);
        }
    }
}

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


namespace Fountain.WinConsole.OtherDemo
{
    internal class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Server=127.0.0.1;Database=CRMS;User Id=sa;Password=pwd123456;";
            using (IDbConnection connection = new SqlConnection(connectionString))
            {
                var result = connection.Query<UserEntity>("select * from user");
                foreach (var entity in result)
                {
                    Console.WriteLine($"{entity.Code}, {entity.Name}");
                }
            }
        }
    }
    /// <summary>
    /// 用戶實(shí)體
    /// </summary>
    public class UserEntity
    {
        /// <summary>
        /// 編碼
        /// </summary>
        public int Code { get; set; }
        /// <summary>
        /// 名稱
        /// </summary>
        public string Name { get; set; }
    }
}

using SqlSugar;
using System.Data;
using System.Xml;
using static System.Net.Mime.MediaTypeNames;


namespace Fountain.WinConsole.OtherDemo
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //數(shù)據(jù)庫鏈接
            var db = new SqlSugarClient(new ConnectionConfig()
            {
                ConnectionString = "Server=127.0.0.1;Database=CRMS;User Id=sa;Password=sa123456;",
                //指定數(shù)據(jù)庫類型
                DbType = SqlSugar.DbType.SqlServer,
                //鏈接使用完后是否自動(dòng)釋放
                IsAutoCloseConnection = true,
            });
            // 獲取
            UserEntity userEntity= db.Queryable<UserEntity>().First();
            // 輸出
            Console.WriteLine($"{userEntity.Code}, {userEntity.Name}");
            // 按任意鍵推出
            Console.ReadLine();
        }
    }
    /// <summary>
    /// 用戶實(shí)體
    /// </summary>
    public class UserEntity
    {
        /// <summary>
        /// 編碼
        /// </summary>
        public int Code { get; set; }
        /// <summary>
        /// 名稱
        /// </summary>
        public string Name { get; set; }=string.Empty;
    }
}