Fundamentals of Crud in .net

100%

Fundamentals of Crud in .net

✓ Published0🌍 Public

Last edited Mar 14, 2026

Created on Mar 14, 2026

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.

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

62% match

Loading thumbnail…

Linq exercises I did in .NetFiddle

This example showcases a series of LINQ (Language Integrated Query) exercises in C# that progressively build from basic filtering to grouping and aggregation. The code, stored as a gist by abonello, defines a TaskItem class with Id, Title, and Completed properties, then demonstrates core LINQ operations including Where for filtering, OrderBy for sorting, Select for projection, Count and Any for aggregation, and FirstOrDefault for element retrieval. The exercises also include GroupBy to summarize completed vs. pending tasks, with each iteration refining the approach—starting with inline ForEach loops, moving to a reusable PrintTasks helper method, and finally exploring concise query syntax with null-conditional operators. The examples show practical patterns for querying in-memory collections, making it useful for developers learning LINQ or preparing for coding interviews.

Aabonello

60% 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

56% 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

55% match

Loading thumbnail…

Simple database

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.

Aabonello

53% match

Loading thumbnail…

Task List

This interactive task list demonstrates how to add, filter, and delete tasks in a web application. Users type a new task into a form, submit it to create a list item, and can click a remove icon to delete individual entries with a confirmation dialog. A search field dynamically filters visible tasks as the user types, while a “Clear Tasks” button removes all entries at once. The code uses vanilla JavaScript event listeners for form submissions and clicks, jQuery for DOM manipulation, and Materialize CSS for styling the interface.

Bbukbukbukka

52% match

Loading thumbnail…

JS Bin

This example demonstrates JavaScript object constructors and method definitions using plain functions and the `new` keyword. It creates a `Task` constructor with properties for `name` and `completed`, as well as `complete` and `save` methods that log actions to the console. Four task instances are instantiated, with one marked complete and the others saved. The code uses no external libraries or data sources, relying entirely on native JavaScript syntax and console output to illustrate basic object-oriented patterns.

JJaxonDvl

51% match

Loading thumbnail…

Gist 74fe605a7286aaa4f524

This example demonstrates a command-line and file-management reference guide, showing terminal commands for Windows cmd, Putty, and Meteor.js setup alongside a simple to-do list app creation workflow. The visualization presents the commands and directory structures as a static educational cheat sheet, using plain text and formatting to organize the information. No JavaScript libraries or data APIs are employed; the content is rendered directly from the gist’s source code. The data source is the textual documentation authored by Darius9, displaying commands like `cd`, `rm -rf`, and `meteor create` without interactive behavior.

DDarius9

51% match