dotNet/Npgsql の変更点

追加された行はこの色です。
削除された行はこの色です。
dotNet/Npgsql へ行く。
dotNet/Npgsql の差分を削除
* Npgsql [#xa2fef08]

** DbProviderFactory [#wa71f1ac]
 <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 Pooling [#i1064e96]
http://stackoverflow.com/questions/2383551/storing-connection-in-a-static-class-asp-net

** SQL IN [#y36893d8]
 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);
 }

- http://fxjr.blogspot.jp/2009/05/npgsql-tips-using-in-queries-with.html
- http://stackoverflow.com/questions/16634282/npgsql-statement-in-pass-an-array-of-strings
- http://lists.pgfoundry.org/pipermail/npgsql-devel/2008-September/000794.html

** 参考 [#q242f84a]
- http://npgsql.projects.pgfoundry.org/
-- http://npgsql.projects.pgfoundry.org/docs/manual/UserManual.html
- http://www.buildinsider.net/small/npgsql/01