Animal Model 开发指南

【1.安装】

打开Visual Studio 2022 头部菜单扩展->管理扩展->联机搜索 AnModel

点击下载，下载完成后退出Visual Studio 再安装，安装后打开Visual Studio 2022 头部菜单工具--> AnModel++

【2.运行】

工具打开之后，如下界面

选择数据库类型、输入数据库连接字符串、选择支持的特性类库

----------------------------------------------------------------------------------

SQLSERVER 连接字符串格式:

Data Source = 127.0.0.1;Initial Catalog = DBName;User Id = sa;Password = 123;

MySQL：

Server=127.0.0.1;Database=DBName;Uid=root;Pwd=123;

----------------------------------------------------------------------------------

点击Run按钮，工具会弹出保存路径，生成数据库下所有表对象类，下面是每种特性类生成的代码

Dapper

using System;
using Dapper.Contrib.Extensions;

[Table("loginlog")]
public class loginlog
{
/// <summary>
/// 编号[自增长]
/// </summary>
[Key]
public int id { get; set; }
/// <summary>
/// 登录账号
/// </summary>
public string acccountid { get; set; }
/// <summary>
/// 注释
/// </summary>
public string memo { get; set; }
/// <summary>
/// 登录日期默认为当前时间
/// </summary>
public DateTime logindate { get; set; }
/// <summary>
/// ip地址
/// </summary>
public string ip { get; set; }
/// <summary>
/// 状态 1sucess 0 fail
/// </summary>
public int status { get; set; }
}

SqlSugar

using System;
using SqlSugar;

[SugarTable("loginlog")]
public class loginlog
{
/// <summary>
/// 编号[自增长]
/// </summary>
[SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnName = "id")]
public int id { get; set; }
/// <summary>
/// 登录账号
/// </summary>
public string acccountid { get; set; }
/// <summary>
/// 注释
/// </summary>
public string memo { get; set; }
/// <summary>
/// 登录日期默认为当前时间
/// </summary>
public DateTime logindate { get; set; }
/// <summary>
/// ip地址
/// </summary>
public string ip { get; set; }
/// <summary>
/// 状态 1sucess 0 fail
/// </summary>
public int status { get; set; }
}

AnimalORM

using System;
using Animal.ORM.Model;

[Tiger("loginlog")]
public class loginlog
{
/// <summary>
/// 编号[自增长]
/// </summary>
[Koala(true)]
[Cat("id")]
public int id { get; set; }
/// <summary>
/// 登录账号
/// </summary>
[Cat("acccountid")]
public string acccountid { get; set; }
/// <summary>
/// 注释
/// </summary>
[Cat("memo")]
public string memo { get; set; }
/// <summary>
/// 登录日期默认为当前时间
/// </summary>
[Cat("logindate")]
public DateTime logindate { get; set; }
/// <summary>
/// ip地址
/// </summary>
[Cat("ip")]
public string ip { get; set; }
/// <summary>
/// 状态 1sucess 0 fail
/// </summary>
[Cat("status")]
public int status { get; set; }
}

Default

using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

[Table("loginlog")]
public class loginlog
{
/// <summary>
/// 编号[自增长]
/// </summary>
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
[Key]
public int id { get; set; }
/// <summary>
/// 登录账号
/// </summary>
public string acccountid { get; set; }
/// <summary>
/// 注释
/// </summary>
public string memo { get; set; }
/// <summary>
/// 登录日期默认为当前时间
/// </summary>
public DateTime logindate { get; set; }
/// <summary>
/// ip地址
/// </summary>
public string ip { get; set; }
/// <summary>
/// 状态 1sucess 0 fail
/// </summary>
public int status { get; set; }
}

Nothing

using System;

public class loginlog
{
/// <summary>
/// 编号[自增长]
/// </summary>
public int id { get; set; }
/// <summary>
/// 登录账号
/// </summary>
public string acccountid { get; set; }
/// <summary>
/// 注释
/// </summary>
public string memo { get; set; }
/// <summary>
/// 登录日期默认为当前时间
/// </summary>
public DateTime logindate { get; set; }
/// <summary>
/// ip地址
/// </summary>
public string ip { get; set; }
/// <summary>
/// 状态 1sucess 0 fail
/// </summary>
public int status { get; set; }
}