基本信息
源码名称:通用数据库操作。支持Sql Server_Oracle_MySQL_Sqlite。
源码大小:2.96M
文件格式:.zip
开发语言:C#
更新时间:2024-11-08
友情提示:(无需注册或充值,赞助后即可获取资源下载链接)
嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):813200300
本次赞助数额为: 5 元×
微信扫码支付:5 元
×
请留下您的邮箱,我们将在2小时内将文件发到您的邮箱
源码介绍
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Linq;
using System.Runtime.Serialization.Json;
using System.Text;
using System.Web.Script.Serialization;
using DBUtil;
namespace DBUtilConsoleApp
{
class Program
{
static void Main(string[] args)
{
DBSession db = new DBSession(DataBaseType.MsSql);
string sel_sql = string.Empty;
DataTable dt = new DataTable();
//Test();
}
static void SWatch(Action act)
{
Stopwatch wat = new Stopwatch();
wat.Start();
act();
wat.Stop();
long lng = wat.ElapsedMilliseconds;
Console.WriteLine(lng);
}
long SWatch(Action<object> act, object o)
{
Stopwatch wat = new Stopwatch();
wat.Start();
act(o);
wat.Stop();
return wat.ElapsedMilliseconds;
}
static void Test()
{
DBSession db = new DBSession(DataBaseType.MsSql);
string sel_sql = string.Empty;
DataTable dt = new DataTable();
//sel_sql = "select top 10 * from product order by id desc";
//dt = db.QueryTable(sel_sql);
//db = new DBSession(DataBaseType.MySql);
//sel_sql = "select * from product order by id desc limit 1,10 ";
//dt = db.QueryTable(sel_sql);
//db = new DBSession(DataBaseType.Oracle);
//sel_sql = "Select * From Cc_Qa Where Rownum<=10 Order By added Desc ";
//dt = db.QueryTable(sel_sql);
//db = new DBSession(DataBaseType.OracleManaged);
//sel_sql = "Select * From Cc_Qa Where Rownum<=10 Order By added Desc ";
//dt = db.QueryTable(sel_sql);
//db = new DBSession(DataBaseType.Sqlite);
//sel_sql = "select * from base_datalog order by opertime desc limit 1,10";
//dt = db.QueryTable(sel_sql);
//db = new DBSession(DataBaseType.Oledb);
//sel_sql = "Select * From product Order By settime Desc ";
//dt = db.QueryTable(sel_sql);
}
}
}