使用npgsql执行postgres脚本

我有一个脚本(*.sql)创建表。我正在使用Visual studio 2010与npgsql访问postgres数据库。

我可以从后台执行一个脚本吗?

这是我试过的代码:

string sqlConnectionString = @"myconnection";
FileInfo file = new FileInfo(@"myfile.sql");
string script = file.OpenText().ReadToEnd();
NpgsqlConnection conn = new NpgsqlConnection(sqlConnectionString);
Server server = new Server(new ServerConnection(conn));
server.ConnectionContext.ExecuteNonQuery(script);
file.OpenText().Close();

But But Visual studio不识别Server

NpgsqlConnection _connPg = new NpgsqlConnection("yourconnectionstring"));
FileInfo file = new FileInfo(HttpContext.Current.Server.MapPath("DatabaseSchema.sql"));
string script = file.OpenText().ReadToEnd();
var m_createdb_cmd = new NpgsqlCommand(script, _connPg);
_connPg.Open();
m_createdb_cmd.ExecuteNonQuery();
_connPg.Close();