Documentation Home

Welcome to KnightMoves.SqlObjects documentation!

• Overview
  • What is it?
  • What problem does it solve?
• Quick Start
• SELECT FROM
  • SELECT ALL
  • COLUMN
  • COLUMNS
  • DISTINCT
  • TOP
• JOIN
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
• INSERT
• UPDATE
• DELETE
• WHERE
  • Basic Syntax
  • Comparison Operators
  • AND
  • OR
  • BETWEEN
  • IN
  • LIKE
• CASE
• GROUP BY
• ORDER BY
• HAVING
• UNION
• Calculations
  • Arithmetic Operators
  • Using .COLUMN()
  • Using .Calculate()
  • Using .CASE()
  • Using .WHEN()
  • In the .WHERE() Clause
• Subqueries
• Functions
  • ABS
  • AVG
  • CEILING
  • COUNT
  • DATEADD
  • DATEDIFF
  • DATENAME
  • DATEPART
  • DAY
  • EXISTS
  • FLOOR
  • GETDATE
  • ISNULL
  • MAX
  • MIN
  • MONTH
  • SUM
  • YEAR
• Scripts
  • Overview
  • Script() vs. Literal()
  • Script() Example
  • Literal() Example
• Comments
  • Simple Single Line Comments
  • Multi-Line Comments
• Serialization
  • ToJson()
  • FromJson()
  • Custom Serialization
• Parameterized Queries
• Debugging
• Security
  • Overview
  • Parameterized Queries
  • Strongly Typed Values
  • Interpolated Strings
  • Sanitization
  • Attack Detection
• Advanced Concepts
  • Overview
  • Sharing Columns
  • Adding To & Merging SQL Objects
  • Terminate()
  • WithId() / FindById()
  • WithName()
  • WithDoc()
  • Walking the Tree
  • Checking Fragment Types
• Support
• License
  • Developer Tool Limited License v1.0
• Release Notes
  • 1.3.0
  • 1.2.0
  • 1.1.0
  • 1.0.0

Indices and tables

• Index

• Module Index

• Search Page