PDF.NET SOD 开源框架红包派送活动 新手快速入门指引

AdoHelper helper=new SqlServer();
DataSet ds=helper.ExecuteDataSet( ”Data Source=.;Initial Catalog=LocalDB;Integrated Security=True”,CommandType.Text,”SELECT * FROM Table_User”);

helper=new Access(); //Access数据库访问类
DataSet dsAcc=helper.ExecuteDataSet( ”Provider=Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Engine Type=6;Data Source=D:\Data\SuperMarket.accdb”,CommandType.Text,”SELECT * FROM Table_User”);

<connectionStrings><add name="AccessDb"

  connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Engine Type=6;Data Source= |DataDirectory|SuperMarket.accdb"

  providerName="Access"/></connectionStrings>

<add name="default" connectionString="server=10.0.0.1;User Id=pdfnet;password=pdfnet2015;CharSet=utf8;DataBase=test;Allow Zero Datetime=True" 
providerName="PWMIS.DataProvider.Data.MySQL,PWMIS.MySqlClient"/>

using PWMIS.DataProvider.Adapter;//…
AdoHelper accessDb1=MyDB.Instance;//应用程序配置文件连接配置节的最后一个数据连接配置
AdoHelper accessDb2=MyDB.GetDBHelperByConnectionName(“AccessDb”); //连接字符串名字

AdoHelper mySqlDb=MyDB.GetDBHelperByConnectionName(“default”); //连接字符串名字 
bool flag= accessDb.GetType() == typeof(Access); //flag=true;

bool flag2= mySqlDb.GetType() == typeof(PWMIS.DataProvider.Data.MySQL); //flag2=true;

AdoHelper dbLocal = new SqlServer();
dbLocal.ConnectionString = "Data Source=.;Initial Catalog=LocalDB;Integrated Security=True";
var dataList = dbLocal.GetList(reader =>
{return new{UID=reader.GetInt32(0),Name=reader.GetString(1)};
}, "SELECT UID,Name FROM Table_User WHERE Sex={0} And Height>={1:5.2}",1, 1.60M);

//假设UserPoco 对象跟 Table_User 表是映射的相同结构
AdoHelper dbLocal = new SqlServer();
dbLocal.ConnectionString = "Data Source=.;Initial Catalog=LocalDB;Integrated Security=True";
var list=dbLoal.QueryList<UserPoco>("SELECT UID,Name FROM Table_User WHERE Sex={0} And Height>={1:5.2}",1, 1.60M);

public class UserEntity:EntityBase, IUser{public UserEntity(){TableName = "Users";IdentityName = "User ID";PrimaryKeys.Add("User ID");}public int UserID{get { return getProperty<int>("User ID"); }set { setProperty("User ID", value); }}public string FirstName{get { return getProperty<string>("First Name"); }set { setProperty("First Name", value,20); }}public string LasttName{get { return getProperty<string>("Last Name"); }set { setProperty("Last Name", value,10); }}public int Age{get { return getProperty<int>("Age"); }set { setProperty("Age", value); }}}

EntityBuilder.RegisterType(typeof(IUser), typeof(UserEntity));
UserEntity user = EntityBuilder.CreateEntity<IUser>() as UserEntity;
//实体类作为索引器使用

bool flag = (user["User ID"] == null);//true//删除测试数据
LocalDbContext context = new LocalDbContext();//自动创建表
OQL deleteQ = OQL.From(user).Delete().Where(cmp=>cmp.Comparer(user.UserID,">",0)) //为了安全，不带Where条件是不会全部删除数据的
    .END;
context.UserQuery.ExecuteOql(deleteQ);
Console.WriteLine("插入3条测试数据");
//插入几条测试数据
context.Add<UserEntity>(new UserEntity() {  FirstName ="zhang", LasttName="san" });
context.Add<IUser>(new UserDto() { FirstName = "li", LasttName = "si", Age = 21 });
context.Add<IUser>(new UserEntity() { FirstName = "wang", LasttName = "wu", Age = 22 });//查找姓张的一个用户
UserEntity uq = new UserEntity() { FirstName = "zhang" };
OQL q = OQL.From(uq).Select(uq.UserID, uq.FirstName, uq.Age).Where(uq.FirstName)
.END;//下面的语句等效
//UserEntity user2 = EntityQuery<UserEntity>.QueryObject(q,context.CurrentDataBase);
UserEntity user2 = context.UserQuery.GetObject(q);

 static void TestGOQL(){string sqlInfo="";//下面使用　ITable_User　或者　Table_User均可List<ITable_User> userList =OQL.FromObject<ITable_User>()//.Select() //选全部自断.Select(s => new object[] { s.UID, s.Name, s.Sex }) //仅选取３个字段.Where((cmp, user) => cmp.Property(user.UID) < 100).OrderBy((o,user)=>o.Asc(user.UID)).Limit(5, 1) //限制５条记录每页，取第一页.Print(out sqlInfo).ToList();Console.WriteLine(sqlInfo);Console.WriteLine("User List item count:{0}",userList.Count);}