SQLProvider

Specifies how to handle case sensitivity when generating table and column names.

Specifies the database provider type for the SQL type provider. Each provider has its own specific implementation for SQL generation and data type mapping.

GroupData is for group-by projections

GroupResultItems is an item to create key-igrouping-structure. From the select group-by projection, aggregate operations like Enumerable.Count() is replaced to GroupResultItems.AggregateCount call and this is used to fetch the SQL result instead of actually counting anything

Interface to hide internal members that are typically not needed by the user

The main interface for SQL data context operations. This interface provides all the core functionality for querying, creating, updating, and deleting data through the SQL type provider. Users typically access this through the generated GetDataContext() method.

Interface implemented by generated types that provide access to the underlying data context. This allows access to the ISqlDataContext for advanced operations.

LinkData is for joins with SelectMany

Attribute for mapping entity properties to database columns with different names. Use this when your database column name differs from your preferred F# property name.

Specifies how to represent nullable database columns in the generated types.

Specifies the quote character style for ODBC connections when dealing with table and column names containing spaces or special characters.

Specifies how to handle conflicts when inserting records with duplicate primary keys. Currently supported only on databases that have UPSERT capabilities.

Contains events for monitoring SQL query execution and debugging. Use these events to log, debug, or analyze the SQL queries generated by the type provider.

Specifies the direction for relationship navigation.

Represents a result set as a sequence of rows, where each row is an array of column name-value pairs.

Represents different types of result sets that can be returned from stored procedures.

Represents different types of return values from stored procedures and functions.

Specifies which SQLite library to use for connections. Different libraries may have different capabilities and platform support.