# Bouyei.DbFactory

**Repository Path**: ayrz2010/dbproviderfactory

## Basic Information

- **Project Name**: Bouyei.DbFactory
- **Description**: c#多种数据库通用访问框架(.net framework和.net core)，支持ef和ado.net方式访问，ado.net支持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**: 2018-12-22
- **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"
	});

	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;