ASP. NET MVC uses Petapoco Mini ORM framework +npgsql to drive connected PostgreSQL database (problem summary)

The installation process is simply carried over:

1. Before looking at the code, we need to load npgsql and Petapoco into the current project, and I will use NuGet to add to the current project as follows:

Install-package Npgsql

Install-package Petapoco

2. Take a look at the important code in Web. config

1> Database Connection string

<connectionStrings> <add name ="Postgresql" connectionstring= " server=127.0.0.1; User id=postgres;password=123;database=mono_test; " providername="npgsql"/> </connectionStrings>

2>npgsql Drive configuration file

<!-provider-driven configuration file->
   <system.data>
     <DbProviderFactories>
       <add name = "Npgsql Data Provider" invariant = "Npgsql" support = "FF" description = ". Net Framework Data Provider for Postgresql Server" type = "Npgsql.NpgsqlFactory, Npgsql" />
     </ DbProviderFactories>
   </system.data> 

3. Load Npgsql.dll and Mono.Security.dll into the VS project.

1> these two DLLs into a folder

Open it:

Choose:

Next:

At last:

Reference:

The last of the last:

A demo base feature is available later. Background UI Reference:

thanks to the Elight.mvc author's contribution to the background UI.

Sample diagram:

ASP. NET MVC uses Petapoco Mini ORM framework +npgsql to drive connected PostgreSQL database (problem summary)