Viktoras Mickūnas

.SqlServerSave() support on MS SQL Server versions prior to 2005

2

.SqlServerSave() currently generates sql query for INSERTs/UPDATEs using `OUTPUT INSERTED.*` clause which is not supported by SQL Server versions prior to 2005. I know that this is legacy stuff, but...

Raising an error and short-circuiting the execution of remaining operators

1

In the initial stage of our data processing pipeline, we verify the presence of a predefined set of files. If any of these files are missing, we need to raise...

Specify timeout for .CrossApplySqlServerQuery and .ToSqlCommand

4

Is there a way to specify the SQL command execution timeout for .`CrossApplySqlServerQuery` and `.ToSqlCommand`? I'm trying to run a stored proc using .`CrossApplySqlServerQuery` and consume the result set that...

Running a stored procedure only once after all records in a CSV file have been saved to the database

2

Let's say we have a data pipeline like this: ``` var stream = contextStream .ToSqlCommand("Create tables", Queries.CreateTables) .CrossApplyFolderFiles("Get data file", "data.csv", true) .CrossApplyTextFile("Parse data", FlatFileDefinition.Create( i => new { code...

Problem when generating SQL for .SqlServerSave when using ODBC and OleDB connections

1

There is a problem with generating SQL, since ODBC and OLE DB connections do not support named parameters in INSERT/UPDATE queries. The parameters need to be replaced with ? symbols...

Getting in-memory list from the database stream

13

Hello, is there a way to get an in memory list as an instantiated ` IList` from SQL Server stream and have the database cursor consumed/closed? First I thought extension...

Getting two database streams from the same database connection in parallel

5

Hello, nice package you have here for ETL in .NET! I have a question regarding database streams: Suppose I need to define two streams for two different tables from the...

I was following The Elmish Book and the Fable compilation hangs because of the early Fable 4 version in the tools manifest: 4.0.0-snake-island-alpha-021. When I changed it to 4.9.0, compilation...