Skip to content

Instantly share code, notes, and snippets.

@amarodeabreu
Created February 23, 2021 09:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save amarodeabreu/2223c9df9ee7094aa06cf0f1046ac768 to your computer and use it in GitHub Desktop.
Save amarodeabreu/2223c9df9ee7094aa06cf0f1046ac768 to your computer and use it in GitHub Desktop.
/// <summary>
/// QueryDatabase method that allows stored procedure calls
/// </summary>
/// <param name="connectionName"></param>
/// <param name="storedProcedure"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public DataSet QueryDatabase(string connectionName, string storedProcedure,
Dictionary<string, string> parameters)
{
var dbConnection = new SqlConnection(connectionName);
dbConnection.Open();
SqlCommand cmd = new SqlCommand(storedProcedure, dbConnection) { CommandType = CommandType.StoredProcedure };
if (parameters?.Count > 0)
{
foreach (var item in parameters)
{
cmd.Parameters.Add(new SqlParameter("@" + item.Key, item.Value));
}
}
var dsDataSet = new DataSet();
var daSqlDataAdapter = new SqlDataAdapter { SelectCommand = cmd };
daSqlDataAdapter.Fill(dsDataSet);
dbConnection.Close();
return dsDataSet;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment