Connecting to #PostgreSQL via C#
As a planned expansion to the Mobile SQL client app (https://itunes.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=1325541368&mt=8) for iOS, – soon support for Oracle and Postgre will be added.
The back-end to the app is some C# middleware, and the code it uses to connect to Postgre is as follows;
private static DataTable ExecutePostgre(string strDataSource, string databaseName, string strUsername, string strPassword, string strSQL)
{
const string strDsnTemplate = @”Server={0};User Id={1}; Password={2};Database={3};”;
var sqlConnection = string.Format(strDsnTemplate, strDataSource, strUsername, strPassword, databaseName);
var adapter = new NpgsqlDataAdapter(strSQL, sqlConnection) { SelectCommand = { CommandTimeout = 0 } };
var dataSet = new DataSet();
adapter.Fill(dataSet, “sql”);
return dataSet.Tables[“sql”];
}
Where NpgsqlDataAdapter comes from the Nuget Package Npgsql, which is installed using
Install-Package Npgsql
-
December 25, 2017 at 11:45 amConnecting to #PostgreSQL via C# | Premium apps reviews Blog and Programing