Search Results for

    Show / Hide Table of Contents

    stable unstable next patch build gitter

    Getting Started

    The best way to use Npgsql is to install its nuget package.

    Npgsql aims to be fully ADO.NET-compatible, its API should feel almost identical to other .NET database drivers. Here's a basic code snippet to get you started.

    var connString = "Host=myserver;Username=mylogin;Password=mypass;Database=mydatabase";
    
    await using var conn = new NpgsqlConnection(connString);
    await conn.OpenAsync();
    
    // Insert some data
    await using (var cmd = new NpgsqlCommand("INSERT INTO data (some_field) VALUES (@p)", conn))
    {
        cmd.Parameters.AddWithValue("p", "Hello world");
        await cmd.ExecuteNonQueryAsync();
    }
    
    // Retrieve all rows
    await using (var cmd = new NpgsqlCommand("SELECT some_field FROM data", conn))
    await using (var reader = await cmd.ExecuteReaderAsync())
        while (await reader.ReadAsync())
            Console.WriteLine(reader.GetString(0));
    

    You can find more info about the ADO.NET API in the MSDN docs or in many tutorials on the Internet.

    • Improve this Doc
    In This Article
    Back to top © Copyright 2020 The Npgsql Development Team