Orcle

Database

Create Database

CREATE DATABASE EStore;

Create Table

CREATE TABLE Category(
    CategoryId INTEGER NOT NULL PRIMARY KEY,
    CategoryName VARCHAR2(64) not null,
    Description VARCHAR2(128) NOT NULL
);

Insert Data

INSERT INTO Category (CategoryId, CategoryName, Description) VALUES (1, 'Laptop', 'Danh mục máy tính xách tay');
INSERT INTO Category (CategoryId, CategoryName, Description) VALUES (2, 'Keyboard', 'Danh mục bàn phím máy vi tính');
INSERT INTO Category (CategoryId, CategoryName, Description) VALUES (2, 'Mouse', 'Danh mục Chuột máy tính');
COMMIT;

Code C#

Add Package from nuget Mysql

dotnet add package Oracle.ManagedDataAccess.Core

Connect C# to My SQL

using System.Data;
using System.Data;
using Oracle.ManagedDataAccess.Client;
string connectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl))); User Id =system;Password=0R@cle!23;";
IDbConnection connection = new OracleConnection(connectionString);
IDbCommand command = connection.CreateCommand();
command.CommandText = "SELECT * FROM Category";
connection.Open();
IDataReader reader = command.ExecuteReader();
while(reader.Read()){
    System.Console.WriteLine("{0}, {1}", reader["CategoryId"], reader["CategoryName"]);
}
reader.Dispose();
command.Dispose();
connection.Dispose();