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 INvar 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); }
参考 |
|