Question 1

How do I get started with SqlHydra in an F# project?

Accepted Answer

Install the SqlHydra.Cli tool locally using dotnet tool install, run it to generate types from your database with a wizard, add the SqlHydra.Query package, and use the generated QueryContextFactory to write type-safe queries with computation expressions, as shown in the Quick Start.

Question 2

SqlHydra vs Entity Framework for F# – which should I use?

Accepted Answer

SqlHydra focuses on compile-time type safety and F#-idiomatic queries using computation expressions, while Entity Framework offers a more mature ecosystem with features like change tracking. Choose SqlHydra for maximal type safety in F#, but Entity Framework if you need broader .NET integration and ORM features.

Question 3

How to handle dynamic where clauses in SqlHydra?

Accepted Answer

You can use conditional where clauses with F# boolean expressions, as shown in the README's 'Conditional Where' section, but queries must remain statically typed. For fully dynamic SQL, you might need to fall back to custom SqlKata operations or raw SQL with HydraReader.

Question 4

Can SqlHydra work with stored procedures?

Accepted Answer

The README doesn't explicitly support stored procedures; for custom SQL, you can use the kata operation or HydraReader for raw queries, but type-safe invocation of stored procedures isn't directly covered, potentially requiring manual mapping.

Question 5

How to update generated types after database schema changes?

Accepted Answer

Run the SqlHydra CLI tool again; the README suggests automating this with a build event target in your project file to regenerate on rebuild in debug mode, ensuring the code stays in sync with the schema.

Question 6

Does SqlHydra support transactions across multiple operations?

Accepted Answer

Yes, SqlHydra provides transaction support by sharing a QueryContext across operations, as demonstrated in the 'Sharing a QueryContext Transaction' example, allowing atomic commits for inserts, updates, and deletes within a single task.

Question 7

How to add custom SQL functions in SqlHydra queries?

Accepted Answer

Use the sqlFn helper to define custom function wrappers, as described in the SQL functions section; these translate function names and arguments to SQL at runtime, enabling integration of database-specific functions not in built-in extensions.

SqlHydra

What is SqlHydra?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions