Skip to content

Getting Started (Libraries)

These quick start samples are only relevant if you are using Prisma/DB libraries instead of the Prisma/DB proxy.

Non-Query Execution

PrismaSqlConnection conn = new PrismaSqlConnection(connectionString);
PrismaSqlCommand command = new PrismaSqlCommand("INSERT INTO table1 (col1, col2, col3) VALUES (1, 2, 'abc')", conn);
conn.Open();
int res = command.ExecuteNonQuery();
Console.WriteLine(res);
conn.Close();
conn.Dispose();

Query Result Execution with using

using (var conn = new PrismaSqlConnection(connectionString))
{
    conn.Open();

    using (var command = new PrismaSqlCommand("SELECT col1, col2, col3 FROM table1", conn))
    {
        using (var reader = command.ExecuteReader())
        {
            Console.WriteLine($"{reader.Columns[0].ColumnName}, " +
                                $"{reader.Columns[1].ColumnName}, " +
                                $"{reader.Columns[2].ColumnName}");

            while (reader.Read())
            {
                Console.WriteLine($"{reader[0]}, {reader[1]}, {reader[2]}");
            }
        }
    }
}