沈
沈世鈞
Guest
open System.Data;;
open System.Data.SqlClient;;
let connString = new SqlConnectionStringBuilder();;
connString.DataSource <- @"Data Source=20.2.2.200;Initial Catalog=Project_Cert_Test;User ID=sa;Password=xxxx;Connect Timeout=60;MultipleActiveResultSets=True";;
let query() =
let query = "SELECT * FROM Project"
seq { let conn_string = connString.ConnectionString
use conn = new SqlConnection(conn_string)
do conn.Open ()
use comm = new SqlCommand(query, conn)
use reader = comm.ExecuteReader()
while reader.Read() do
yield (reader.GetString 0) };;
query();;
why have this limit, how to allow exceed this limit?極意
Continue reading...
open System.Data.SqlClient;;
let connString = new SqlConnectionStringBuilder();;
connString.DataSource <- @"Data Source=20.2.2.200;Initial Catalog=Project_Cert_Test;User ID=sa;Password=xxxx;Connect Timeout=60;MultipleActiveResultSets=True";;
let query() =
let query = "SELECT * FROM Project"
seq { let conn_string = connString.ConnectionString
use conn = new SqlConnection(conn_string)
do conn.Open ()
use comm = new SqlCommand(query, conn)
use reader = comm.ExecuteReader()
while reader.Read() do
yield (reader.GetString 0) };;
query();;
why have this limit, how to allow exceed this limit?極意
Continue reading...