crud operations in postgresql with .net mvc without entity framework

Question

crud operations in PostgreSQL database with .net MVC without entity framework

Sachin Singh · Answer

test this using Npgsql; public void Test() { var cs = "Host=localhost;Username=postgres;Password=s$cret;Database=testdb" ; using var con = new NpgsqlConnection(cs); con.Open(); using var cmd = new NpgsqlCommand(); cmd.Connection = con; cmd.CommandText = "DROP TABLE IF EXISTS cars" ; cmd.ExecuteNonQuery(); cmd.CommandText = @"CREATE TABLE cars(id SERIAL PRIMARY KEY, name VARCHAR(255), price INT )"; cmd.ExecuteNonQuery(); cmd.CommandText = "INSERT INTO cars(name, price) VALUES('Audi',52642)" ; cmd.ExecuteNonQuery(); cmd.CommandText = "INSERT INTO cars(name, price) VALUES('Mercedes',57127)" ; cmd.ExecuteNonQuery(); cmd.CommandText = "INSERT INTO cars(name, price) VALUES('Skoda',9000)" ; cmd.ExecuteNonQuery(); cmd.CommandText = "INSERT INTO cars(name, price) VALUES('Volvo',29000)" ; cmd.ExecuteNonQuery(); cmd.CommandText = "INSERT INTO cars(name, price) VALUES('Bentley',350000)" ; cmd.ExecuteNonQuery(); cmd.CommandText = "INSERT INTO cars(name, price) VALUES('Citroen',21000)" ; cmd.ExecuteNonQuery(); cmd.CommandText = "INSERT INTO cars(name, price) VALUES('Hummer',41400)" ; cmd.ExecuteNonQuery(); cmd.CommandText = "INSERT INTO cars(name, price) VALUES('Volkswagen',21600)" ; cmd.ExecuteNonQuery(); Console.WriteLine( "Table cars created" ); }

Muhammad Imran Ansari · Answer

Check these step-by-step tutorial for CRUD operations without EF. https://www.completecsharptutorial.com/mvc-articles/insert-update-delete-in-asp-net-mvc-5-without-entity-framework.php https://www.c-sharpcorner.com/UploadFile/a20beb/how-you-can-crud-operations-in-postrgre-sql-database-using-a/