F# 连接到在线 MySQL 数据库执行查询

使用F#连接到在线MySQL数据库执行查询可以帮助我们轻松地获取和处理数据库中的数据。在本文中，我们将介绍如何使用F#连接到MySQL数据库，并执行一些常见的查询操作。我们还将提供一个实际的案例代码来帮助您更好地理解这个过程。

bash
dotnet add package MySqlConnector

fsharp
open MySql.Data.MySqlClient
let connectionString = "server=localhost;user=root;database=mydatabase;password=mypassword"

fsharp
let connection = new MySqlConnection(connectionString)

fsharp
let query = "SELECT * FROM customers"
let command = new MySqlCommand(query, connection)
let reader = command.ExecuteReader()
while reader.Read() do
    let customerId = reader.GetInt32(0)
    let customerName = reader.GetString(1)
    printfn "Customer ID: %d, Customer Name: %s" customerId customerName
reader.Close()

fsharp
open MySql.Data.MySqlClient
let connectionString = "server=localhost;user=root;database=mydatabase;password=mypassword"
let connection = new MySqlConnection(connectionString)
let query = "SELECT employee_id, first_name, last_name FROM employees"
let command = new MySqlCommand(query, connection)
let reader = command.ExecuteReader()
while reader.Read() do
    let employeeId = reader.GetInt32(0)
    let firstName = reader.GetString(1)
    let lastName = reader.GetString(2)
    printfn "Employee ID: %d, Name: %s %s" employeeId firstName lastName
reader.Close()