Skip to content

Instantly share code, notes, and snippets.

@rainbyte
Forked from pizycki/QuickStart.fs
Created November 25, 2019 16:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rainbyte/36620a1288424659d60c65ca19c04603 to your computer and use it in GitHub Desktop.
Save rainbyte/36620a1288424659d60c65ca19c04603 to your computer and use it in GitHub Desktop.
MySQL, Dapper and F#
// Place this in .fsproj
// <ItemGroup>
// <PackageReference Include="Dapper.Contrib" Version="1.60.1" />
// <PackageReference Include="MySqlConnector" Version="0.56.0" />
// </ItemGroup>
open Dapper
open MySql.Data.MySqlClient
// CREATE TABLE `8833_rw_dev`.`Releases` (
// `MovieTitle` VARCHAR(200) NULL);
[<CLIMutable>]
type ReleaseRow =
{
Id: int
MovieTitle: string
}
[<EntryPoint>]
let main argv =
let connString = "server=mysql-server;uid=user;pwd=*******;database=db"
let dbConn: MySqlConnection = new MySqlConnection(connString)
let sql = "SELECT * FROM Releases"
let rows = dbConn.Query<ReleaseRow>(sql)
for r in rows do
printfn "%O" r
0 // return an integer exit code
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment