Yanor.net/
Wiki
Blog
GitHub
Sandbox
開始行:
* Npgsql [#xa2fef08]
** DbProviderFactory [#wa71f1ac]
<configuration>
<connectionStrings>
<add name="DefaultConnection"
connectionString="Server=pgsql.example.com;Port=...
providerName="Npgsql" />
</connectionStrings>
<system.data>
<DbProviderFactories>
<add name="Npgsql Data Provider" invariant="...
description=".Net Framework Data Provider fo...
type="Npgsql.NpgsqlFactory, Npgsql, Version=...
</DbProviderFactories>
</system.data>
</configuration>
DescriptionのVersionはプロジェクト内の参照設定を見て合わ...
** Connection Pooling [#i1064e96]
http://stackoverflow.com/questions/2383551/storing-connec...
** SQL IN [#y36893d8]
var names = new string[] {"taro", "hana"};
var sql = String.Format("SELECT * FROM users WHERE name ...
var all = cn.Query(sql, new { names = names });
foreach (var row in all) {
Console.WriteLine("ID:{0}, NAME:{1}", row.id, row.na...
}
- http://fxjr.blogspot.jp/2009/05/npgsql-tips-using-in-qu...
- http://stackoverflow.com/questions/16634282/npgsql-stat...
- http://lists.pgfoundry.org/pipermail/npgsql-devel/2008-...
** 参考 [#q242f84a]
- http://npgsql.projects.pgfoundry.org/
-- http://npgsql.projects.pgfoundry.org/docs/manual/UserM...
- http://www.buildinsider.net/small/npgsql/01
終了行:
* Npgsql [#xa2fef08]
** DbProviderFactory [#wa71f1ac]
<configuration>
<connectionStrings>
<add name="DefaultConnection"
connectionString="Server=pgsql.example.com;Port=...
providerName="Npgsql" />
</connectionStrings>
<system.data>
<DbProviderFactories>
<add name="Npgsql Data Provider" invariant="...
description=".Net Framework Data Provider fo...
type="Npgsql.NpgsqlFactory, Npgsql, Version=...
</DbProviderFactories>
</system.data>
</configuration>
DescriptionのVersionはプロジェクト内の参照設定を見て合わ...
** Connection Pooling [#i1064e96]
http://stackoverflow.com/questions/2383551/storing-connec...
** SQL IN [#y36893d8]
var names = new string[] {"taro", "hana"};
var sql = String.Format("SELECT * FROM users WHERE name ...
var all = cn.Query(sql, new { names = names });
foreach (var row in all) {
Console.WriteLine("ID:{0}, NAME:{1}", row.id, row.na...
}
- http://fxjr.blogspot.jp/2009/05/npgsql-tips-using-in-qu...
- http://stackoverflow.com/questions/16634282/npgsql-stat...
- http://lists.pgfoundry.org/pipermail/npgsql-devel/2008-...
** 参考 [#q242f84a]
- http://npgsql.projects.pgfoundry.org/
-- http://npgsql.projects.pgfoundry.org/docs/manual/UserM...
- http://www.buildinsider.net/small/npgsql/01
ページ名: