AdoNetCore.AseClient

Table of Contents

Downloads

Objectives

Performance benchmarks

Test methodology

Single read, without pooling

Single read, with pooling

Multiple reads, without pooling

Multiple reads, with pooling

Multiple reads, multiple times, without pooling

Multiple reads, multiple times, with pooling

Multiple reads, multiple writes, without pooling

Multiple reads, multiple writes, with pooling

Environment

Server:

Client:

Test results

Connection strings

Supported types

Types supported when sending requests to the database

Types supported when reading responses from the database

Code samples

Open a database connection

varconnectionString="Data Source=myASEserver;Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";using(varconnection=newAseConnection(connectionString)){connection.Open();// use the connection...}

Execute a SQL statement and read response data

varconnectionString="Data Source=myASEserver;Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";using(varconnection=newAseConnection(connectionString)){connection.Open();using(varcommand=connection.CreateCommand()){command.CommandText="SELECT FirstName, LastName FROM Customer";using(varreader=command.ExecuteReader()){// Get the results.while(reader.Read()){varfirstName=reader.GetString(0);varlastName=reader.GetString(1);// Do something with the data...}}}}

Execute a SQL statement that returns no results

varconnectionString="Data Source=myASEserver;Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";using(varconnection=newAseConnection(connectionString)){connection.Open();using(varcommand=connection.CreateCommand()){command.CommandText="INSERT INTO Customer (FirstName, LastName) VALUES ('Fred', 'Flintstone')";varrecordsModified=command.ExecuteNonQuery();}}

Execute a SQL statement that returns a scalar value

varconnectionString="Data Source=myASEserver;Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";using(varconnection=newAseConnection(connectionString)){connection.Open();using(varcommand=connection.CreateCommand()){command.CommandText="SELECT COUNT(*) FROM Customer";varresult=command.ExecuteScalar();}}

Use input parameters with a SQL query

varconnectionString="Data Source=myASEserver;Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";using(varconnection=newAseConnection(connectionString){connection.Open();using(varcommand= connection.CreateCommand()){command.CommandText="SELECT TOP 1 FirstName FROM Customer WHERE LastName = @lastName";command.Parameters.AddWithValue("@lastName","Rubble");varresult=command.ExecuteScalar();}}

Execute a stored procedure and read response data

varconnectionString="Data Source=myASEserver;Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";using(varconnection=newAseConnection(connectionString){connection.Open();using(varcommand= connection.CreateCommand()){command.CommandText="GetCustomer";command.CommandType=CommandType.StoredProcedure;command.Parameters.AddWithValue("@lastName","Rubble");using(varreader=command.ExecuteReader()){// Get the results.while(reader.Read()){varfirstName=reader.GetString(0);varlastName=reader.GetString(1);// Do something with the data...}}}}

Execute a stored procedure that returns no results

varconnectionString="Data Source=myASEserver;Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";using(varconnection=newAseConnection(connectionString)){connection.Open();using(varcommand=connection.CreateCommand()){command.CommandText="CreateCustomer";command.CommandType=CommandType.StoredProcedure;command.Parameters.AddWithValue("@firstName","Fred");command.Parameters.AddWithValue("@lastName","Flintstone");command.ExecuteNonQuery();}}

Execute a stored procedure that returns a scalar value

varconnectionString="Data Source=myASEserver;Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";using(varconnection=newAseConnection(connectionString)){connection.Open();using(varcommand=connection.CreateCommand()){command.CommandText="CountCustomer";command.CommandType=CommandType.StoredProcedure;varresult=command.ExecuteScalar();}}

Use input, output, and return parameters with a stored procedure

varconnectionString="Data Source=myASEserver;Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";using(varconnection=newAseConnection(connectionString)){connection.Open();using(varcommand=connection.CreateCommand()){command.CommandText="GetCustomerFirstName";command.CommandType=CommandType.StoredProcedure;command.Parameters.AddWithValue("@lastName","Rubble");varoutputParameter=command.Parameters.Add("@firstName",AseDbType.VarChar);outputParameter.Direction=ParameterDirection.Output;varreturnParameter=command.Parameters.Add("@returnValue",AseDbType.Integer);returnParameter.Direction=ParameterDirection.ReturnValue;command.ExecuteNonQuery();//Do something with outputParameter.Value and returnParameter.Value...}}

Execute a stored procedure and read response data withDapper

varconnectionString="Data Source=myASEserver;Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";using(varconnection=newAseConnection(connectionString)){connection.Open();varbarneyRubble=connection.Query<Customer>("GetCustomer",new{lastName="Rubble"},commandType:CommandType.StoredProcedure).First();// Do something with the result...}