> ## Documentation Index
> Fetch the complete documentation index at: https://easyaf.nimbleapps.cloud/llms.txt
> Use this file to discover all available pages before exploring further.

# SqlGenerator

> Generates SQL DDL statements from entity metadata.

## Definition

**Assembly:** CloudNimble.BlazorEssentials.TursoDb.dll

**Namespace:** CloudNimble.BlazorEssentials.TursoDb.Schema

**Inheritance:** System.Object

## Syntax

```csharp theme={"dark"}
CloudNimble.BlazorEssentials.TursoDb.Schema.SqlGenerator
```

## Summary

Generates SQL DDL statements from entity metadata.

## Methods

###  GenerateAllDdl

Generates all DDL statements needed to create the table and indexes.

#### Syntax

```csharp theme={"dark"}
public static System.Collections.Generic.IEnumerable<string> GenerateAllDdl(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `metadata` | `CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata` | The entity metadata. |

#### Returns

Type: `System.Collections.Generic.IEnumerable<string>`
All SQL DDL statements.

### &#x20;GenerateCount

Generates a SELECT COUNT(\*) statement.

#### Syntax

```csharp theme={"dark"}
public static string GenerateCount(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `metadata` | `CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata` | The entity metadata. |

#### Returns

Type: `string`
The SQL COUNT statement.

### &#x20;GenerateCreateIndexes

Generates CREATE INDEX statements for all indexed columns.

#### Syntax

```csharp theme={"dark"}
public static System.Collections.Generic.IEnumerable<string> GenerateCreateIndexes(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `metadata` | `CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata` | The entity metadata. |

#### Returns

Type: `System.Collections.Generic.IEnumerable<string>`
The SQL CREATE INDEX statements.

### &#x20;GenerateCreateTable

Generates a CREATE TABLE IF NOT EXISTS statement for the entity.

#### Syntax

```csharp theme={"dark"}
public static string GenerateCreateTable(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `metadata` | `CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata` | The entity metadata. |

#### Returns

Type: `string`
The SQL CREATE TABLE statement.

### &#x20;GenerateDelete

Generates a DELETE statement for the entity.

#### Syntax

```csharp theme={"dark"}
public static string GenerateDelete(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `metadata` | `CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata` | The entity metadata. |

#### Returns

Type: `string`
The SQL DELETE statement.

### &#x20;GenerateInsert

Generates an INSERT statement for the entity.

#### Syntax

```csharp theme={"dark"}
public static string GenerateInsert(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata, string columns, string placeholders)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `metadata` | `CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata` | The entity metadata. |
| `columns` | `string` | The column names. |
| `placeholders` | `string` | The parameter placeholders. |

#### Returns

Type: `string`
The SQL INSERT statement.

### &#x20;GenerateSelectAll

Generates a SELECT \* statement for the entity.

#### Syntax

```csharp theme={"dark"}
public static string GenerateSelectAll(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `metadata` | `CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata` | The entity metadata. |

#### Returns

Type: `string`
The SQL SELECT statement.

### &#x20;GenerateSelectByKey

Generates a SELECT statement to find by primary key.

#### Syntax

```csharp theme={"dark"}
public static string GenerateSelectByKey(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `metadata` | `CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata` | The entity metadata. |

#### Returns

Type: `string`
The SQL SELECT statement.

### &#x20;GenerateUpdate

Generates an UPDATE statement for the entity.

#### Syntax

```csharp theme={"dark"}
public static string GenerateUpdate(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata, string setClause)
```

#### Parameters

| Name | Type | Description |
| - | - | - |
| `metadata` | `CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata` | The entity metadata. |
| `setClause` | `string` | The SET clause. |

#### Returns

Type: `string`
The SQL UPDATE statement.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.