# Bouyei.DbFactory

**Repository Path**: itjac/dbproviderfactory

## Basic Information

- **Project Name**: Bouyei.DbFactory
- **Description**: 高性能数据库通用访问库，支持sql server ,db2,oracle,my sql,postgresql等多种数据库
- **Primary Language**: C#
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 51
- **Created**: 2019-03-15
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#1、Ado使用例子
 
	string connectionString = "Data Source=.;Initial Catalog=testdb;User ID=sa;Password=bouyei;";

	IAdoProvider adoProvider = AdoProvider.CreateProvider(connectionString);

	var rt = adoProvider.Query(new Parameter()
	{
		CommandText = "select * from MemUser"
	});

	//删除
	var del= adoProvider.Delete<user>(x => x.name == "hello");

	//插入
	  var insert = adoProvider.Insert<user>(new user() {
                 name="bouyei",
                 age=30
            });

	//查询
	var users = adoProvider.Query<user>(x => 1 == 1);

	foreach (DataRow dr in rt.Result.Rows)
	{
		Console.WriteLine(string.Join(",", dr.ItemArray));
	}

#基于EF的ORM需要再配置文件加相应实体映射dll路径，详细看demo代码例子

	IOrmProvider ormProvider = OrmProvider.CreateProvider(ProviderType.SqlServer, connectionString);

	var items= ormProvider.Query<DbEntity.User>("select * from MemUser").ToList();

	foreach(var item in items)
	{
		Console.WriteLine(item.uName);
	}
	Console.ReadKey();

#sql表达式生成例子
			//生成简单查询脚本
            ISqlProvider sqlProvider = SqlProvider.CreateProvider();

            //查询
           var sql= sqlProvider.Select<User>()
                .From<User>().Where<User>(x => x.Id == 1).SqlString;

            //修改
            sql = sqlProvider.Update<User>()
                .Set<User>(new User() { Name = "bouyei", UserName = "hkj" })
                .Where<User>(x => x.Id == 1).SqlString;

            //删除
            sql = sqlProvider.Delete()
                .From<User>().Where<User>(x => x.Name == "bouyei").SqlString;

            //插入
            sql = sqlProvider.Insert<User>()
                .Values<User>(new User[] {
                new User() { Name ="hello", UserName="aileenyin.com" }
                ,new User() { Name="bouyei",UserName="jiang"} }).SqlString;