Executing Non-Returning Queries
Exposed by adapters that return no data, the Execute method is the simplest of the adapter methods generated by .netSavant.
In this example you'll see that we're performing a simple insert operation that returns no data:
1: private static void AuditDownload(HttpRequest request) {
2: using (SqlConnection connection = new SqlConnection(ApplicationState.ConnectionString)) {
3: using (InsertFileDownloadHistoryAdapter adapter = new InsertFileDownloadHistoryAdapter(connection)) {
4: adapter.FileId = 1;
5: adapter.Browser = request.ServerVariables["HTTP_USER_AGENT"];
6: adapter.IP = request.ServerVariables["REMOTE_ADDR"];
7: adapter.Execute();
8: }
9: }
10: }
If your statement returns output parameters, simply access the adapter properties that expose the parameter after calling the Execute() method.
1: private static void AuditDownload(HttpRequest request) {
2: using (SqlConnection connection = new SqlConnection(ApplicationState.ConnectionString)) {
3: using (InsertFileDownloadHistoryAdapter adapter = new InsertFileDownloadHistoryAdapter(connection)) {
4: adapter.FileId = 1;
5: adapter.Browser = request.ServerVariables["HTTP_USER_AGENT"];
6: adapter.IP = request.ServerVariables["REMOTE_ADDR"];
7: adapter.Execute();
7: Console.WriteLine(adapter.AuditId.ToString());
8: }
9: }
10: }