上一篇已经介绍了如何搭建windows环境下C#连接GBase 8s数据库的环境,这篇就介绍一下,怎么使用吧
先来个简单的Demo
GbsConnectionStringBuilder build = new GbsConnectionStringBuilder();
build.Host = “192.168.1.1”;
build.Service = “8080”;
build.Server = “server”;
build.Database=“dbname”;
build.UID=“root”;
build.Pwd=“a”;
GbsConnection conn = new GbsConnection(build.ConnectionString);
conn.Open();
using(GbsCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select * from user";
GbsDataReader dr = cmd.ExecureReader();
while(dr.Read())
{
Console.WriteLine(dr["id"]);
}
}
host:数据库ip
service:端口
server:实例名称
database:数据库名称
uid:用户名
pwd:密码
还可以设置字符集
ClientLocale
DbLocale
字符集一定要和数据库的设置成一致哒。
正常显示结果,木问题~