End-User Documentation

Statement Type API

Statement Type API

All end-user wrappers inherit from SqlStatement and expose the same lazy validation surface.

Wrapper Types

  • SqlQuery
  • SqlInsert
  • SqlUpdate
  • SqlDelete
  • SqlMerge
  • SqlStoredProc

Shared Members

  • Text
  • StatementType
  • Parameters
  • IsValid
  • Errors
  • Warnings
  • ErrorSummary
  • ToString()
  • implicit string

Constructor Pattern

Statement constructors accept raw SQL, optional validationParameters, and an optional per-statement dialectProfile override.

var query = new SqlQuery(
    "SELECT * FROM dbo.orders WHERE order_id = @Id",
    validationParameters: new { Id = 42 },
    dialectProfile: DialectProfile.SqlServer2019);

Related