NpgsqlDbProviderFactory <configuration>
<connectionStrings>
<add name="DefaultConnection"
connectionString="Server=pgsql.example.com;Port=5432;User Id=taro;Password=mypass;Database=my_db;SSL=True;Sslmode=Require"
providerName="Npgsql" />
</connectionStrings>
<system.data>
<DbProviderFactories>
<add name="Npgsql Data Provider" invariant="Npgsql" support="FF"
description=".Net Framework Data Provider for Postgresql Server"
type="Npgsql.NpgsqlFactory, Npgsql, Version=2.0.1.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />
</DbProviderFactories>
</system.data>
</configuration>
DescriptionのVersionはプロジェクト内の参照設定を見て合わせる。 Connection Poolinghttp://stackoverflow.com/questions/2383551/storing-connection-in-a-static-class-asp-net SQL IN var names = new string[] {"taro", "hana"};
var sql = String.Format("SELECT * FROM users WHERE name = any (@names)");
var all = cn.Query(sql, new { names = names });
foreach (var row in all) {
Console.WriteLine("ID:{0}, NAME:{1}", row.id, row.name);
}
参考 |
|
