WPF Prism框架-3.通过IOC注入方式简单ORM操作Mysql数据库

使用到的ORM框架

SqlSugarCore

SqlSugar 是一款简单易用的开源 ORM 框架，支持.NET CORE 和 MySql、SqlServer、Sqlite、Oracle 、 postgresql 、达梦、人大金仓 数据库，具有 EF NH 的功能，比 EF 更人性化的语法，支持真实的批量操作，另外还有媲美 DAPPER 的性能。

开源地址：dotNET China/SqlSugar ORM

文档地址：http://donet5.com/Home/Doc

安装SqlSugarCore包

项目结构

创建 SqlSugarConfig 数据库连接配置类

connectionString 解释

Data Source 数据库地址
Database 数据库名字
User Id 登录用户名
Password 密码
charset 文字编码
port 端口号

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using DbType = SqlSugar.DbType;

namespace WXCode.DB
{
    
    public class SqlSugarConfig
    {
    
        private static readonly string connectionString = "Data Source=xx.xx.xx.xx;Database=test_db;User Id='testuser';Password='aacccsshgdjw123';charset=utf8;port=3306";

        public static SqlSugarClient GetInstance()
        {
    
            var db = new SqlSugarClient(new ConnectionConfig()
            {
    
                ConnectionString = connectionString,
                DbType = DbType.MySql,
                IsAutoCloseConnection = true,
                InitKeyType = InitKeyType.Attribute
            });

            return db;
        }
    }
}

通过 Prism框架 的IOC注入单例数据库对象

App.xaml.cs

using Microsoft.Data.SqlClient.Server;
using Microsoft.Data.Sqlite;
using Prism.Ioc;
using SqlSugar;
using System;
using System.Windows;
using WXCode.DB;
using WXCode.Views;

namespace WXCode
{
    
    /// <summary>
    /// Interaction logic for App.xaml
    /// </summary>
    public partial class App
    {
    
        protected override Window CreateShell()
        {
    
            return Container.Resolve<MainWindow>();
        }

        protected override void RegisterTypes(IContainerRegistry containerRegistry)
        {
    
            /// 注入SqlSugarClient对象
            containerRegistry.RegisterSingleton<SqlSugarClient>(()=>SqlSugarConfig.GetInstance());
        }
    }
}

在MainWindow.xaml.cs中简单测试一下Sql

using Prism.Ioc;
using Prism.Modularity;
using SqlSugar;
using System.Collections.Generic;
using System;
using System.Windows;
using WXCode.DB;

namespace WXCode.Views
{
    
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
    
        private SqlSugarClient _sqlSugarClient;
        public MainWindow(IContainerExtension container, SqlSugarClient sqlSugarClient)
        {
    
            InitializeComponent();
            this._sqlSugarClient = sqlSugarClient;

            int count = _sqlSugarClient.Ado.GetInt("select count(*) from user");
            MessageBox.Show("查询数量："+ count, "MainWindow");
        }
    }
}

运行效果