Simple database

100%

Simple database

✓ Published0🌍 Public

Last edited Mar 14, 2026

Created on Mar 14, 2026

This example shows how to create a simple relational database with two tables, Customers and Orders, using raw SQL. It demonstrates the use of IDENTITY columns for auto-generated primary keys and FOREIGN KEY constraints to enforce referential integrity between the tables. The code also includes a JOIN query that combines customer names with their corresponding order details, illustrating basic data retrieval without an ORM. The example relies on standard SQL Server syntax and T-SQL commands, including CREATE TABLE, CONSTRAINT, and SELECT with JOIN.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist f227f5d1e19ba9632c805fd11e03a76a

This example demonstrates a minimal CRUD API for managing customer records, built with ASP.NET Core and Entity Framework Core. It defines endpoints for creating, reading, updating, and deleting customers, with each operation interacting with a SQL Server database via `AppDbContext`. The code includes commented-out seed data and console output for testing, while the active HTTP routes use `MapGet`, `MapPost`, `MapPut`, and `MapDelete` to return JSON results through `Results.Ok`, `Results.Created`, and `Results.NotFound`. Swagger UI is enabled in development to document the API endpoints.

Aabonello

61% match

Loading thumbnail…

Gist 79872f318f741408f6c6a418c5104465

This example demonstrates how to modify a SQL Server table schema by converting the `Status` column from a bit data type to an NVARCHAR(50) field with a default value of 'Pending'. It shows the process of dropping the existing default constraint, altering the column type, and then re-adding a new constraint. The code uses SQL Server T-SQL commands such as `ALTER TABLE`, `DROP CONSTRAINT`, and `ADD CONSTRAINT` to achieve the migration. The example is based on a gist by abonello and references the `Orders` table from a SalesDB database, highlighting the foreign key relationship with the `Customers` table.

Aabonello

58% match

Loading thumbnail…

Gist be32a2ac117700d3dbde6b0824367ba5

This example demonstrates how to create a simple database table visualization from a SQL schema definition. The code defines a `Demo` table with three columns—`ID`, `Key`, and `Value`—and shows how to map those column types and constraints into a visual entity-relationship style diagram. Using the provided `CREATE TABLE` statement as the data source, the visualization renders each column as a node, with the primary key and nullable attributes indicated through distinct visual encodings. The implementation leverages `d3.forceSimulation` for the node layout and `d3.geoPath` for any geometric rendering, while relying on standard DOM elements for interactivity. No additional behavior beyond the table’s structural representation is implied.

HHugoberry

57% match

Loading thumbnail…

Concept for inserting data into SQL Server

This example demonstrates a concept for inserting data into SQL Server by using Power Query’s M language. It shows a table creation script for a demo table with an identity column, a key, and a value, followed by an M query that iterates over a list of key-value pairs. The code uses `List.Accumulate` to loop through the pairs and calls `OleDb.DataSource` with a SQL `INSERT` statement for each iteration, referencing the SQLOLEDB provider to connect to a local database. The result is the total number of affected records from the inserts, though the actual inserted rows are not visualized or returned in the output.

HHugoberry

54% match

Loading thumbnail…

Example Program.cs

This example shows a complete minimal API backend for customer management, wired to a React frontend. It demonstrates EF Core’s `AppDbContext` for SQL Server data access, including `EnsureCreated` seeding of three initial customers. CORS policy `MyAllowSpecificOrigins` permits requests from `http://localhost:5173`. The code exposes `MapGet`, `MapPost`, `MapPut`, and `MapDelete` endpoints for CRUD operations, with Swagger enabled for development testing.

Aabonello

53% match

Loading thumbnail…

Very Simple IndexedDB Example

This example demonstrates basic IndexedDB operations, including database creation, object store setup, index management, and data retrieval. It shows how to open a database named “MyDatabase” and create an object store with a keyPath of “id” and a compound index on name fields. The code adds two records with nested name objects and then queries them both by primary key and by index lookup, logging results to the console. It uses the native IndexedDB API with cross-browser fallbacks, including the IndexedDBShim for unsupported environments.

Aamundo

53% match

Loading thumbnail…

Fundamentals of Crud in .net

A console application demonstrates fundamental CRUD operations against a SQL Server database using Microsoft.Data.SqlClient. The program begins by reading and displaying all tasks from the Tasks table, then inserts a new task, updates a task’s completed status, and deletes a task, showing the updated table contents after each operation. SQL commands are executed through SqlConnection, SqlCommand, and SqlDataReader, with parameterized queries preventing SQL injection. The code illustrates the complete create, read, update, and delete workflow in a simple task-management context.

Aabonello

53% match

Loading thumbnail…

Scaffold an ASP.Net project

This example demonstrates how to scaffold an ASP.NET Core Web API project that connects to a SQL Server database using Entity Framework Core. It shows the step-by-step setup of the backend structure, including creating model classes for `Customer` and `Order`, defining an `AppDbContext` that bridges these C# models to database tables via `DbSet` properties, and configuring the connection string in `appsettings.json`. The code uses `Microsoft.EntityFrameworkCore` and `Microsoft.EntityFrameworkCore.SqlServer` packages to enable the database context and query capabilities.

Aabonello

52% match