• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

easy4net: easy4net是一个轻量级orm框架,灵活在于可以自己编写复杂的SQL语句查询,简 ...

原作者: [db:作者] 来自: 网络 收藏 邀请

开源软件名称:

easy4net

开源软件地址:

https://gitee.com/wangwei123/easy4net

开源软件介绍:

easy4net是一个轻量级orm框架,灵活在于可以自己编写复杂的SQL语句查询,简单在于几分钟内便能上手使用,并支持mysql, mssql, oracle, access, sqlite数据库. easy4net技术QQ 群:162695864

分页查询:

    1. 命名参数, ParamMap传参方式:
    1. 支持多层嵌套查询自动分页功能。

int pageIndex = 1;int pageSize = 3;string strSql = "SELECT e.*, c.company_name FROM employee e INNER JOIN company c ON e.company_id = c.id WHERE e.name = @name";ParamMap param = ParamMap.newMap();param.setPageParamters(page, limit);//分页时使用的排序字段,必填,请带上SQL表名的别名,如employee的为: eparam.setOrderFields("e.id", true);param.setParameter("name", "LiYang");//MySQLString是app.config或web.config中配置的连接数据库字符串,//应部分用户需要可以切换多个数据库要求Session session = SessionFactory.GetSession("MySQLString");List<Employee> emList = session.Find<Employee>(strSql, param);

分页查询:

    1. 命名参数, ParamMap传参方式:
    1. 返回总条数和数据集合的对象PageResult

public PageResult<Store> findByPage(int page, int limit){    Session session = SessionFactory.GetSession("MySQLString");    String sql = "select * from store";    ParamMap param = ParamMap.newMap();    param.setPageParamters(page, limit);    param.setOrderFields("id", true);    PageResult<Store> pageResult = session.FindPage<Store>(sql, param);    return pageResult;}public class PageResult<T>{    /// <summary>    /// 分页查询中总记录数    /// </summary>    public int Total {get; set;}    /// <summary>    /// 分页查询中结果集合    /// </summary>    public List<T> DataList {get; set;}}

查询单条记录:


string strSql = "SELECT e.*, c.company_name FROM employee e INNER JOIN company c ON e.company_id = c.id WHERE e.name = @name";ParamMap param = ParamMap.newMap();param.setParameter("name", "LiYang");Employee em = session.Get<Employee>(strSql, param);

普通查询:


string strSql = "SELECT e.*, c.company_name FROM employee e INNER JOIN company c ON e.company_id = c.id";List<Employee> emList = session.Find<Employee>(strSql);

新增:

    1. 新增后返回新增记录的主键id值
    1. 主键id值已经自动填充到新增的对象entity中

//创建公司Company company = new Company();company.CompanyName = txtName.Text.Trim();company.Industry = txtIndustry.Text.Trim();company.Address = txtAddress.Text.Trim();Session session = SessionFactory.GetSession("MySQLString");session.Insert<Company>(company);if (company.Id > 0) {    MessageBox.Show("创建公司成功!");}//新增员工Company company = m_CompanyList[cbCompany.SelectedIndex]; Employee employee = new Employee();employee.Name = txtName.Text.Trim();mployee.Age = Convert.ToInt32(txtAge.Text.Trim());employee.Address = txtAddress.Text.Trim();employee.Created = DateTime.Now;employee.CompanyId = company.Id;Session session = SessionFactory.GetSession("MySQLString");session.Insert<Employee>(employee);if (employee.Id > 0){    MessageBox.Show("新增员工成功!");}

批量新增:

    1. 主键id值已经自动填充到新增的对象entity中
    1. 批量新增方法比手动循环多个对象然后调用新增性能高。

List<Company> companyList = ...;Session session = SessionFactory.GetSession("MySQLString");session.Insert(companyList);

修改:


Company entity = new Company();entity.Id = 1;entity.Name = "百度";Session session = SessionFactory.GetSession("MySQLString");session.Update(entity);

批量修改:

    1. 批量修改方法比手动循环多个对象然后调用修改性能高。

Session session = SessionFactory.GetSession("MySQLString");List<Company> companyList = ...;Session session = SessionFactory.GetSession("MySQLString");session.Update(companyList);

删除:

    1. 按对象方式删除数据
    1. 按主键id方式删除数据

Company company = m_companyList[i];//remove a objectSession session = SessionFactory.GetSession("MySQLString");session.Delete(company);//remove by idsession.Delete(company.Id);

批量删除:

    1. 按对象方式删除数据
    1. 按主键id方式删除数据
    1. 批量删除比手动循环调用删除性能要高

//remove by objectList<Company> companyList = ...;Session session = SessionFactory.GetSession("MySQLString");session.Delete(companyList);//remove by idobject[] ids = new object[]{1,2,3,4,5};session.Delete(ids);

数据库与C#对象映射关系配置:


using System;using System.Collections.Generic;using System.Linq;using System.Text;   namespace Easy4net.Entity  {       [Table(Name = "company")] 	 public class Company	 { 		[Id(Name = "id", Strategy = GenerationType.INDENTITY)]		public int? Id{ get; set; } 		[Column(Name = "company_name")]		public String CompanyName{ get; set; }        [Column(Name = "industry")]        public String Industry { get; set; }        [Column(Name = "address")]        public String Address { get; set; } 	 } }  using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Text;  namespace Easy4net.Entity  {       [Table(Name = "employee")] 	 public class Employee	 { 		[Id(Name = "id", Strategy = GenerationType.INDENTITY)]		public int? Id{ get; set; } 		[Column(Name = "name")]		public String Name{ get; set; } 		[Column(Name = "age")]		public int? Age{ get; set; } 		[Column(Name = "address")]		public String Address{ get; set; } 		[Column(Name = "created")]		public DateTime? Created{ get; set; } 		[Column(Name = "company_id")]		public int? CompanyId{ get; set; }        [Column(Name = "company_name", IsInsert = false, IsUpdate = false)]        public String CompanyName { get; set; } 	 } }   

数据库连接配置 web.config中:

  • dbType中配置sqlserver, mysql, oracle来支持不同的数据库

<?xml version="1.0"?><configuration>    <connectionStrings>    <add name="MySQLString"        connectionString="Data Source=localhost;Initial Catalog=test_db;Persist Security Info=True;User ID=root;Password=123456;Min Pool Size=1;Max Pool Size=3;"        providerName="MySql.Data.MySqlClient" />        <add name="SqlServerString"          connectionString="Data Source=(local);Initial Catalog=Study;User ID=sa;Password=sa;"          providerName="System.Data.SqlClient" />       <add name="OracleString"         connectionString="Data Source=192.168.0.2;Initial Catalog=test;Persist Security Info=True;User ID=user1;Password=pass1"         providerName="System.Data.OracleClient" />    <add name="SQLiteString" connectionString="Data Source=|DataDirectory|\testdb.sqlite;Pooling=true;"       providerName="System.Data.SQLite" />  </connectionStrings>  <startup>  <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/></startup></configuration>

鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
热门推荐
热门话题
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap