C#创建和填充Oracle数据库

using Oracle.ManagedDataAccess.Client;

// 创建连接字符串
string connectionString = "Data Source=oracle_server_address;User Id=username;Password=password;";

// 建立与Oracle数据库的连接
using (OracleConnection connection = new OracleConnection(connectionString))
{
    connection.Open();
    
    // 在此处执行数据库操作
}

using (OracleCommand command = connection.CreateCommand())
{
    // 创建表
    command.CommandText = "CREATE TABLE table_name (column1 datatype, column2 datatype, ...)";
    command.ExecuteNonQuery();
    
    // 创建字段
    command.CommandText = "ALTER TABLE table_name ADD (column_name datatype)";
    command.ExecuteNonQuery();
}

using (OracleCommand command = connection.CreateCommand())
{
    // 插入数据
    command.CommandText = "INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...)";
    command.ExecuteNonQuery();
}