Sqlite memory 数据库
0
悬赏园豆：20
[已关闭问题]
关闭于 2010-08-26 10:32
我在内存中创建数据库，在open() 的时候就报错，看了很多文档都没有找到答案，希望博客园有大牛帮忙解决下，先谢了
IDbConnection dbcon;
dbcon = (IDbConnection)new SQLiteConnection("URI=file::memory:,version=3");
dbcon.Open();
IDbCommand dbcmd = dbcon.CreateCommand();
// requires a table to be created named employee
// with columns firstname and lastname
// such as,
// CREATE TABLE employee (
// firstname varchar(32),
// lastname varchar(32));
string sql =
"SELECT firstname, lastname " +
"FROM employee";
dbcmd.CommandText = sql;
IDataReader reader = dbcmd.ExecuteReader();
while (reader.Read())
{
string FirstName = reader.GetString(0);
string LastName = reader.GetString(1);
Console.WriteLine("Name: " +
FirstName + " " + LastName);
}
// clean up
reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
dbcon.Close();
dbcon = null;
问题补充：
错误信息 Invalid ConnectionString format for parameter "URI"
所有回答(3)
0
你报啥错，你总得把错误贴出来吧。
0
URI=file::memory:,version=3
格式不对......你再检查检查吧......
0
跟你的错误一样，请问i后来解决了吗？
