C#中使用嵌入式firebird数据库代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】 C#中使用嵌入式firebird数据库

作者:Dezai.CN / 发布于2013/2/27/ 667


	using System;
	using System.Collections.Generic;
	using System.Text;
	using FirebirdSql.Data.FirebirdClient;
	namespace CreateDB
	{
	 class Program
	 {
	 static void Main(string[] args)
	 {
	 FbConnection.CreateDatabase(GetConnectionString());

	 using (FbConnection conn = new FbConnection(GetConnectionString()))
	 {
	 conn.Open();
	 using (FbCommand createTable = conn.CreateCommand())
	 {
	 createTable.CommandText = "create table test (id int, word varchar(20) character set win1250)";
	 createTable.ExecuteNonQuery();
	 }
	 using (FbCommand insertData = conn.CreateCommand())
	 {
	 insertData.CommandText = "insert into test values (@id, @word)";
	 for (int i = 0; i < 10; i++)
	 {
	 insertData.Parameters.Clear();
	 insertData.Parameters.Add("@id", FbDbType.Integer).Value = i;
	 insertData.Parameters.Add("@word", FbDbType.VarChar, 20).Value = GetWord(i);
	 insertData.ExecuteNonQuery();
	 }
	 }
	 }
	 }

	 static string GetConnectionString()
	 {
	 FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
	 cs.Database = "test.fdb";
	 cs.UserID = "SYSDBA";
	 cs.Password = "masterkey";
	 cs.Charset = "UTF8";
	 cs.ServerType = FbServerType.Embedded;

	 return cs.ToString();
	 }

	 static string GetWord(int i)
	 {
	 StringBuilder sb = new StringBuilder(i);
	 for (int j = 0; j < i; j++)
	 {
	 sb.Append(i);
	 }
	 return sb.ToString();
	 }
	 }
	}

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　firebird　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)