Sybase database connection with c#

Question

I have a Sybase database file on my machine, I want to make this database available in my application c#, how I make this Sybase database file available, and how to access this database with c#?

Answer 1

With the "SQL Anywhere . NET Data Provider"

You can download it by Nuget and there are two versions:

To the ASA16: iAnywhere.Data.Sqlanywhere.v4. 5

For the ASA2017: Sap.Data.Sqlanywhere

Example:

SAConnection conn = new SAConnection("Data Source=SQL Anywhere 12 Demo");
conn.Open();
SACommand cmd = new SACommand("SELECT Surname FROM Employees", conn);
SADataReader reader = cmd.ExecuteReader();
listEmployees.BeginUpdate();
while (reader.Read())
{
    listEmployees.Items.Add(reader.GetString(0));
}
listEmployees.EndUpdate();
reader.Close();
conn.Close();