0

More than 5 years have passed since last update.

@callmekohei(callmekohei)in

fukuoka.ex：福岡Elixirコミュ

DapperでのIN句（fsharp）

Last updated at 2020-06-04Posted at 2020-06-04

Summary

DapperでIN句

メモ書き

Sql

(
  CASE
    WHEN (@LenFoo = 0 ) THEN
      true
    ELSE
      tbl.AAA IN @Foo
  END
)

or

((tbl.AAA in @Foo) or (@LenFoo = 0)

fsharp

{|
  Foo = foo
  LenFoo = List.length( foo )
|}
|> fun x -> con.Execute(sql,x) |> ignor

foo list の中身

[]
["aaa"]

ref

https://github.com/StackExchange/Dapper#list-support
https://stackoverflow.com/questions/18690395/check-null-for-list-parameter-in-dapper

0

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

0