Classic / Fluent API map
A practical index of the two authoring surfaces and their shared provider contracts.
Examples use Classic and Fluent tabs. Your choice follows you through the manual.
Schema operations
| Classic | Fluent |
|---|---|
| AddTable | Create.Table |
| AddColumn(table, column) | Create.Column(name).OnTable(table) |
| ChangeColumn(table, column) | Alter.Column(name).OnTable(table) / Alter.Column(definition).OnTable(table) |
| RemoveTable / RemoveColumn | Delete.Table(table) / Delete.Column(name).FromTable(table) |
| RenameTable / RenameColumn | Rename.Table(old).To(new) / Rename.Column(old).OnTable(table).To(new) |
| AddPrimaryKey / AddUniqueConstraint / AddCheckConstraint | Create.PrimaryKey(name).OnTable(table).WithColumns(...) / Create.UniqueConstraint / Create.CheckConstraint |
| AddForeignKey / RemoveForeignKey | Create.ForeignKey(name).FromTable(child).WithColumns(...).ToTable(parent).WithColumns(...) / Delete.ForeignKey(name).FromTable(table) |
| AddIndex / RemoveIndex | Create.Index(name).OnTable(table).WithColumns(...) / Delete.Index(name).FromTable(table) |
| GetTableConstraints / GetColumns | Schema.Table(name).ConstraintDefinitions() / Columns() |
Data and execution
| Classic | Fluent |
|---|---|
| Insert / InsertIfNotExists | Insert.IntoTable(...).Row(...) / IfNotExists(...) |
| Update / Delete | Update.Table(...).Set(...).Where(...) / Delete.FromTable(...).Where(...) |
| ExecuteNonQuery / ExecuteScript / ExecuteResourceScript | Execute.Sql / Execute.Script / Execute.EmbeddedScript |
| CopyDataFromTableToTable / UpdateTargetFromSource | Execute.CopyDataFromTable(source).ToTable(target).WithColumns(...) / Execute.UpdateTable(target).FromTable(source).Set(...).Match(...) |
| TruncateTable | Execute.Truncate |
| CreateCommand / Connection | Execute.WithCommand / Execute.WithConnection |
| Database provider access | Context or Execute.WithProvider |
| History / transactions | Shared runner and explicit provider context |
Execution is not preview or reversal
Both APIs reach the same provider layer, but not every operation has SQL-preview or automatic-reversal support. Provider capabilities still govern execution. Read preview, reversal and the machine-checked method-family inventory for the distinction.