database Resources

Share

Related resources for database

A Simple Step to Entity Framework: Code First Approach5/17/2024 11:02:24 AM. Learn the foundational steps of Entity Framework's Code First approach in this straightforward guide. Dive into database development with ease using C# and Visual Studio, mastering Object-Relation
Table Splitting in Entity Framework 6 (Code First Approach)5/17/2024 10:42:39 AM. Table Splitting in Entity Framework 6 (Code First Approach) allows multiple entity types to map to a single database table. This technique is useful for organizing related data within the same table,
Reflecting Data In .NET Classes - Part IV - From Database Table5/17/2024 10:36:57 AM. In this segment of "Reflecting Data In .NET Classes," Part IV focuses on generating .NET classes from database tables. Utilizing reflection, it maps database schema to object-oriented struct
Entity Framework's Database Seed Method5/17/2024 10:35:16 AM. In this article, we will learn Entity Framework Database Seed Method that allows you to seed some dummy data in the database for testing purposes.
Get Comma Separated Values From SQL Server Using Entity Framework (EF)5/17/2024 10:20:28 AM. Learn how to retrieve data from SQL Server using Entity Framework (EF) in C#. This tutorial covers querying with LINQ, transforming results into comma-separated values (CSV), and leveraging EF's d
Understanding ACID: The Foundation of Database Transactions5/17/2024 6:27:51 AM. In the domain of database management, ACID (Atomicity, Consistency, Isolation, Durability) principles assure transaction reliability. This article delves into ACID's history, necessity, evolution,
Working With Stored Procedures Using Entity Framework: Part 15/16/2024 8:32:00 AM. Learn how to leverage Entity Framework for interacting with stored procedures in your .NET applications. This tutorial explores integrating stored procedures into your data access layer, optimizing da
De-Normalization in SQL: Enhancing Database Performance5/16/2024 6:37:20 AM. De-normalization in SQL, born from the limitations of normalization, optimizes database performance by strategically reintroducing redundancy. Balancing performance gains with data integrity remains c
CRUD Operations In ASP.NET MVC 5 Using ADO.NET5/16/2024 5:46:35 AM. Learn how to implement CRUD operations in ASP.NET MVC 5 using ADO.NET. This tutorial covers database connectivity, SQL Server integration, controller actions for Create, Read, Update, and Delete opera
Entity Framework (5), With .Net Core MVC, Database-First5/16/2024 5:33:27 AM. This article will describe Entity Framework with .Net Core MVC, Database-First approach,
Entity Framework (2), With .Net MVC, Database-First5/16/2024 5:08:39 AM. This article will be Entity Framework with .Net MVC, Database-First approach,
Entity Framework (7), With .NET WPF, Database-First5/16/2024 5:08:19 AM. This article describe to develop a WPF app with entity framework, database first approach.
Primary Key in SQL: Syntax, Usages, and Example5/14/2024 11:46:09 AM. A primary key in SQL uniquely identifies each record in a database table. It ensures data integrity and efficient data retrieval. Defined using the CREATE TABLE or ALTER TABLE commands, a primary key
SQL Locks for Data Integrity in Concurrent Environments 5/14/2024 8:24:44 AM. Understanding SQL Locks: Ensuring Data Integrity in Concurrent Environments
SQL Concurrency: Maintaining Data Integrity in Concurrent Environments5/14/2024 7:07:02 AM. Concurrency in databases enables multiple users or processes to access and modify data concurrently, enhancing performance. SQL concurrency ensures data consistency and integrity through locking mecha
CRUD Operations Using Entity Framework 5.0 Code First Approach in MVC5/9/2024 11:56:39 AM. Perform CRUD operations in MVC using Entity Framework 5.0's Code First approach. Define entity classes, utilize DbContext and LINQ for data access, and generate views and controllers with scaffold
Entity Framework: Code First Migrations With the Existing Database5/9/2024 11:52:10 AM. Explore Entity Framework's Code First Migrations to seamlessly integrate existing databases with your application. Learn efficient techniques for data modeling, schema synchronization, and version
Backup Utility In .Net5/9/2024 11:51:13 AM. A Backup Utility in .NET facilitates data protection by enabling automated backups of files or databases. It offers features like compression, encryption, and scheduled backups, ensuring data integrit
Real Time example of GUID in Azure5/9/2024 11:49:29 AM. Azure uses GUIDs (Globally Unique Identifiers) to organize and secure resources. From signing up for services to managing databases, GUIDs ensure seamless operations and data security across various s
Difference between SQL and T-SQL5/9/2024 10:35:19 AM. In the realm of relational database management systems (RDBMS), SQL (Structured Query Language) and T-SQL (Transact-SQL) are often used interchangeably. In this article, we'll delve into the key d
Simple Insert And Select (CRUD) Operation Using .NET Core MVC With ADO.NET And Entity Framework Core5/7/2024 10:33:55 AM. Learn to perform basic CRUD operations in .NET Core MVC using both ADO.NET and Entity Framework Core. Build a robust data access layer for seamless integration with your web application.
Creating Shopping Cart Application From Scratch In MVC - Part Two5/6/2024 11:25:44 AM. Part two of creating a shopping cart app in MVC delves into backend functionalities like database management, session handling, and refining user interactions. It covers features such as adding/removi
Connecting Grafana to Data Sources5/6/2024 5:19:15 AM. Connect Grafana to databases, APIs, and more for powerful data visualization. Link MySQL, PostgreSQL, or InfluxDB seamlessly and extend with plugins for MongoDB, Kafka, REST APIs, and cloud platforms
Convert Rows to CSV & Eliminate Duplicates in SQL Server5/6/2024 4:17:43 AM. Using SQL Server's string aggregate function, efficiently transform row data into a comma-separated format, while simultaneously removing any duplicate entries, ensuring data integrity and optimiz
Database Connectivity in Visual Studio 5/3/2024 9:16:16 AM. Visual Studio facilitates robust database connectivity through technologies like ADO.NET and Entity Framework. Developers can seamlessly integrate with SQL Server, MySQL, Oracle, and more using connec
How To Quickly Change Azure SQL Database Service Level Objectives5/3/2024 9:01:57 AM. To swiftly adjust Azure SQL Database Service Level Objectives (SLOs), utilize Azure Portal's intuitive interface or T-SQL commands for efficient performance tuning. Consider migrating between DTU
Execute Multiple SQL Files On Single Go in SQL Server5/3/2024 4:52:45 AM. Are you utilizing SQL Server? Are deployments still handled manually by certain teams or DBAs? Is there no intention to incorporate CI/CD tools due to project or budget limitations. Nonetheless, there
Creating Calendar in SQL Server5/2/2024 5:48:05 AM. In the below example I have created a simple calendar using sql server and its predefined functions. This SQL script demonstrates creating a simple calendar using SQL Server's temporary tables and
Implement Many-To-Many Relationship in C# Class5/1/2024 11:13:30 AM. Learn to implement a many-to-many relationship in C# using collections and junction tables. Explore how to model associations between entities, use LINQ queries for retrieval, and leverage tools like
How to Bind and Perform Update, Edit, Delete Operation on DataList Control in 3 Tier in ASP.Net5/1/2024 11:10:55 AM. Learn how to implement CRUD operations on a DataList Control in ASP.NET using C#. This tutorial guides you through creating a three-tier architecture with an SQL Server Database, designing the UI, wri
How To Dynamically Upload And Play Video File Using ASP.NET MVC 55/1/2024 5:43:40 AM. This article demonstrates how to upload a video file of up to 100MB and play dynamically using ASP.NET MVC 5. I will upload the video file to my project folder name (VideoFileUpload) and add its path
NHibernate in Details: Part 24/30/2024 9:49:29 AM. Dive deeper into NHibernate with Part 2, exploring advanced topics like session management, querying, and performance optimization. Uncover the intricacies of this powerful object-relational mapping t
Create Table And Put Data In SQL Server Using CSV File 4/30/2024 7:28:46 AM. Learn how to import data from a CSV file into an SQL Server database using SQL Server Management Studio. Follow step-by-step instructions to create a database, import flat files, map fields, and veri
SQL Server Fundamentals: Design, Queries & Optimization4/29/2024 10:52:37 AM. This article serves as a comprehensive guide to SQL Server fundamentals, database design principles, querying with Transact-SQL, stored procedures, and optimization techniques. Through real-time examp
Entity Framework Core: Features, Real-time Implementation, Best Practices4/29/2024 10:27:09 AM. Entity Framework Core (EF Core) stands as a powerful toolset for .NET developers, streamlining the interaction between applications and databases through object-relational mapping (ORM). Whether adopt
Working With Multiple Tables in MVC Using Entity Framework4/29/2024 10:12:37 AM. Learn how to effectively work with multiple database tables in ASP.NET MVC using Entity Framework. Explore entity relationships, database modeling, and data access strategies.
Inserting CSV File Records Into Database Using ASP.NET C#4/29/2024 10:04:27 AM. Inserting CSV file records into a database with ASP.NET C# involves parsing the CSV, establishing a database connection, and inserting data using frameworks like Entity Framework or ADO.NET. Validate
Seed Databases in EntityFramework4/29/2024 9:58:30 AM. Seeding databases in Entity Framework simplifies initial data setup. Utilize migrations and DbContext to seed essential data, ensuring a consistent database state. This approach streamlines developmen
Entity Framework - Database First Approach4/29/2024 9:54:15 AM. Learn Database First approach with Entity Framework. Utilize existing databases to create entity models. Use the ADO.Net Entity Data Model to connect. Customize model options including pluralizing, i
What Is There In SQL Server Integrated Services (SSIS) Toolbox?4/29/2024 4:00:52 AM. This comprehensive overview of SQL Server Integration Services (SSIS) delves into its toolbox, encompassing Control Flow, Data Flow, Variables and Parameters, Event Handlers, Package Explorer, and Con
Getting Started Wth MongoDb Atlas4/26/2024 12:00:41 PM. Learn how to get started with MongoDB Atlas, a cloud-based database service that offers a scalable and flexible solution for managing NoSQL databases. Explore data modeling, cluster configuration, and
Searching Records by DropDownList in ASP.NET4/26/2024 9:54:25 AM. This tutorial guides the creation of a web app to search records via DropDownList. It includes SQL commands to create a database, insert records, and configuring data sources. The process involves set
Database First Approach in MVC 5: Part 24/25/2024 10:41:59 AM. In MVC 5's Database First Approach (Part 2), delve deeper into leveraging Entity Framework for seamless integration with existing databases. Explore scaffolded views, data validation, and CRUD ope
Database First Approach in MVC 5: Part 14/25/2024 10:10:15 AM. This article shows the development of an ASP.NET Web application in an MVC 5 project template that connects with a database that exists already and allows the users to interact with the data.
Database First Approach in MVC 5: Part 34/25/2024 8:02:50 AM. Learn advanced techniques in database design, Entity Framework Designer, and building robust Data Access Layers within the Model-View-Controller architecture.
Ingest Data into Azure SQL Database using SSMS4/25/2024 6:43:37 AM. This video shows how to ingest data into Azure SQL Database using SQL Server Management Studio.
Table Splitting in Entity Framework4/25/2024 5:56:24 AM. Entity Splitting in Entity Framework involves mapping an entity across multiple database tables, aiding in organizing data and optimizing performance. Table Splitting divides a single table into two,
Entity Framework Code First Example4/24/2024 1:24:22 PM. Explore an Entity Framework Code First example to understand database modeling in C#. This tutorial demonstrates object-relational mapping (ORM) techniques, using .NET Framework to create entity class
Data Annotations and Code First Migration in Entity Framework4/24/2024 1:18:51 PM. Explore the seamless integration of Data Annotations and Code First Migration within the Entity Framework. Learn how to leverage annotations to define data models and relationships, and master the art
Mapping TVFs Using Entity Framework Database First4/24/2024 7:43:49 AM. Map table-valued functions (TVFs) in Entity Framework Database First by importing them as function imports. Utilize EDM Designer to create complex types for TVF results, enhancing data retrieval and m
What is SQL Server Integration Services?4/24/2024 5:21:49 AM. SQL Server Integration Services (SSIS) is a robust data integration platform within Microsoft SQL Server, enabling seamless data extraction, transformation, loading, and management tasks efficiently.
How To Convert List <DataTable> Into DataSet4/23/2024 11:15:59 AM. Retrieve employee details from database using stored procedure. Group data by department with LINQ. Export List<DataTable> to Excel with multiple spreadsheets. Bind List<DataTable> to Gri
Customized Auditing In SQL For DDL Operations At Server Level4/23/2024 11:14:16 AM. Explore the intricacies of customized auditing in SQL for DDL operations at the server level. Enhance database security and compliance by implementing tailored logging and monitoring mechanisms.
.NET Remoting: The Interface Approach4/23/2024 9:01:14 AM. .NET Remoting offers efficient remote object interaction, ideal for network resource access. Compared to SOAP-based web services, it's lighter. While easier than Java's RMI, it's more comp
Preview of Dynamic Data and Entity Data For EF 64/23/2024 7:23:32 AM. The preview of Dynamic Data and Entity Data for EF 6 introduces efficient database connectivity and modeling within the .NET Framework. It enables seamless integration of data with code through Entity
Logging Database Operations in Entity Framework4/22/2024 8:53:24 AM. Discover Entity Framework 6's new feature: logging database operations. Easily debug and troubleshoot performance issues by logging SQL commands, parameters, timestamps, and more. Customize loggin
Understanding VARCHAR and NVARCHAR in SQL Server4/22/2024 4:00:34 AM. VARCHAR and NVARCHAR are essential data types in SQL Server for storing character data. Understanding the differences between these data types is crucial for designing efficient database schemas and o
Understanding the Layers of Database Management Systems4/21/2024 2:29:09 PM. Unlocking the Power of Three-Tier Architecture: A Comprehensive Guide to Understanding and Implementing Database Management Systems. Dive deep into the layers of presentation, application, and data ma
Zero To Hero In MS SQL Server - Part One4/19/2024 10:51:18 AM. This is part one of Zero To Hero Series in MS SQL Server. This is mainly focused for beginners who are into MS SQL Server and also for experienced who want to fresh up for interviews and daily technic
Zero To Hero In MS SQL Server - Part Five4/19/2024 10:32:41 AM. Embark on a journey from novice to expert in MS SQL Server with Part Five of our comprehensive series. Explore advanced topics including query optimization, stored procedures, indexing strategies, and
Zero To Hero In MS SQL Server - Part Four4/19/2024 10:31:37 AM. In this article, Part Four of 'Zero To Hero In MS SQL Server' delves into advanced topics like query optimization, stored procedures, and indexing strategies. Master database management, T-SQL
Zero To Hero In MS SQL Server - Part Two4/19/2024 10:30:33 AM. Advance your MS SQL Server skills from Part One to mastery with Part Two. Dive into advanced T-SQL, stored procedures, triggers, and performance tuning techniques for efficient database management and
SQL Stored Procedures: Benefits, Implementation & Best Practices4/19/2024 9:52:48 AM. Stored procedures are a powerful feature of SQL databases that allow developers to encapsulate SQL logic and execute it as a single unit. In this article, we'll delve into the concept of stored pr
Understanding OLTP and OLAP for Effective Data Management4/19/2024 6:03:17 AM. This article explores OLTP and OLAP, two crucial systems for data management. OLTP handles real-time transactions, while OLAP analyzes historical data to uncover valuable insights. Learn how they work
Select Query With Logical Operator in a Mongo Database Using C# Driver4/18/2024 1:28:05 PM. Learn how to perform select queries in MongoDB using C# driver. Explore JSON-style object representation, conditional operators, insertion, and retrieval of data. Connect to MongoDB, serialize and des
Select Stored Proc With Raw SQL Query Via EDF Framework4/18/2024 10:43:47 AM. Utilize Entity Data Framework (EDF) for selecting stored procedures with raw SQL queries. Enhance data access in your application by leveraging the power of SQL alongside EDF's object-relational m
Using Table Valued Function for Data Selection - EDF Framework 5.04/18/2024 10:27:02 AM. Learn efficient data retrieval techniques using Table Valued Functions (TVF) through Data Entity Model in EDF Framework 5.0. Enhance database operations by leveraging TVFs within Entity Framework, sim
Reducing Complexity Using Entity Framework Core Owned Types4/18/2024 8:45:52 AM. Simplify data modeling in Entity Framework Core with Owned Types. Streamline database schema and relationships, reducing complexity in code-first approaches. Enhance maintainability and readability wi
A Comprehensive Guide to Entity Framework Core in .NET 84/16/2024 10:54:12 AM. Explore the comprehensive guide to Entity Framework Core in .NET 8, enriched with the latest features of C# 10. Authored by Ziggy Rafiq, this detailed overview covers everything from basic concepts to
Generate Dynamic Models in C# .NET 8 MVC from Database4/16/2024 10:20:45 AM. Creating a C# .NET 8 MVC Application To Generate Dynamic Models From A Database Table. This article demonstrates how to dynamically generate models in C# .NET MVC based on database table schemas, stre
Create a Single Page App with Blazor Server and Entity Framework Core 3.0 4/16/2024 5:34:48 AM. Create dynamic web applications efficiently using Blazor Server, a .NET Core framework, coupled with Entity Framework Core 3.0 for seamless data integration. Leverage C# to build interactive, single-p
Installing EF Core with Empty Template in ASP.NET MVC Core 3.04/15/2024 11:49:21 AM. Discover how to seamlessly integrate Entity Framework Core into your ASP.NET MVC Core 3.0 application using an empty template. Follow a step-by-step installation guide to set up the data access layer
How to Insert Console Application with Entity Framework 4/15/2024 11:41:37 AM. Learn how to seamlessly integrate a console application with Entity Framework for efficient database operations. Explore how to perform CRUD (Create, Read, Update, Delete) operations within your .NET
Create, Copy, Rename And Delete SQL Database In Azure4/13/2024 6:14:54 PM. Learn to manage SQL databases in Azure: create, copy, rename, and delete. Follow step-by-step instructions using Azure portal and SQL Server Management Studio. Efficiently handle database tasks for ef
CRUD Operation with Dapper Using ASP.NET Core4/13/2024 5:08:16 PM. Using Dapper for CRUD operations in ASP.NET Core is straightforward and efficient. Dapper is a micro ORM that provides simple methods to execute SQL queries and map results to objects. Here's a ba
What is Alibaba Cloud Lindrom (ACL) ?4/12/2024 5:52:19 AM. In this article, we will learn Alibaba Cloud Lindorm is a cloud-native multi-model hyper-converged database service developed and optimized for IoT, the Internet, and the Internet of Vehicles (IoV).
Create A Database Project From Existing SQL Database 4/11/2024 7:03:00 AM. In this post, we will see how to create a database project from existing SQL database. We will modify the project by adding a table into the project and add seed data through post deployment script. W
Enhance SQL Server Queries with OPTION(RECOMPILE) Hint4/11/2024 6:56:49 AM. This article provides an in-depth exploration of the OPTION(RECOMPILE) hint in SQL Server, offering developers and database administrators a thorough understanding of its functionality, practical appl
Insert, Update and Delete Data in HTML54/11/2024 6:18:40 AM. Learn to perform CRUD operations in HTML5 using JavaScript and SQL. Create a form with text boxes and buttons for data manipulation. Use JavaScript to interact with the database, showing, updating, an
How To Unlock HR Schema In Oracle-12C Or How To Fix The ORA - 01033 Error 4/10/2024 10:41:23 AM. In this article, I explain how to unlock the HR schema in Oracle 12c in detail. Sometimes while making the clone of production database into a test server this type of error occurs. So this article is
Core Concept Of ERD (Entity Relationship Diagram)4/9/2024 8:43:47 AM. In this article, we will learn The core concept of Entity Relationship Diagram (ERD) lies in visually representing the relationships between entities in a database system. It illustrates how different
Learn about SQL Table Variable?4/9/2024 4:58:06 AM. Table variables in SQL Server function similarly to temporary tables but with some constraints. They offer local scope and structure definition but lack certain features like non-clustered indexes and
Set Default Value To Dropdown List From Database In ASP.NET MVC4/8/2024 8:21:07 AM. In this article, you will learn how to populate a dropdown list in ASP.NET MVC with default values retrieved from a database. Utilize Entity Framework to fetch data and bind it to the SelectList.
Multi-Tenancy with Separate Databases Approach in .NET Core4/8/2024 5:44:25 AM. In this article, we will learn how to implement a separate database approach of multi-tenancy in the .Net Core application and how to provide a dynamic connection string to DbContext
Employee Salary Updates Using SQL Update with Inner Join Query4/5/2024 9:16:51 AM. Explore how to update employee salaries while ensuring that each employee has only one salary per job. We'll accomplish this task using the UPDATE statement with INNER JOIN in SQL. Let's dive
How to Use Stored Procedure in PHP4/5/2024 5:42:14 AM. Using stored procedures in PHP involves connecting to a database using MySQLi or PDO, preparing and executing SQL queries that call the stored procedures. Utilize parameterized queries for security an
Power of Filtered Indexes in SQL Server4/5/2024 4:28:34 AM. Discover the power of filtered indexes in SQL Server with our concise guide. Explore practical applications and key benefits, empowering you to harness the full potential of SQL Server for enhanced da
Dynamically Getting Stored Procedures Collection From SQL Server Using C#4/4/2024 9:32:40 AM. In this article, we will learn how to dynamically fetch stored procedures from Microsoft SQL Server using C# for enhanced database interaction. This tutorial explores C#'s capabilities to programm
Generate the Client Side Hash Password Via MD5 Algorithm and Saving it to Database4/4/2024 9:10:42 AM. This article shows how to convert a plain password to a hashed password using the MD5 algorithm on the client side and save it to the database.
Connecting SQLite Database to Mobile App with Flutter and Dart4/4/2024 8:33:05 AM. To integrate an SQLite database into your Flutter mobile app, follow these steps: Add dependencies, create a database helper class for CRUD operations, use it in your app, handle async operations, and
Learn About Power BI Data Source Options And SQL Database Connection - Part One4/4/2024 7:25:57 AM. Explore Power BI's diverse data source options and its seamless connection to SQL databases in this informative series. Learn about querying, data integration, visualization, and more in Part One,
Mirroring Snowflake Database in Fabric Warehouse4/4/2024 2:52:55 AM. In this video, I walk you through how to get started with Snowflake Database, create warehouse, database, tables and records and mirrored the database in Fabric Database for downstream analytics. If y
Advanced Joins In SQL Server 20174/3/2024 10:50:44 AM. Explore the intricacies of SQL Server 2017 with advanced join techniques. Master inner, outer, cross, and self joins to optimize database queries. Elevate your SQL skills with join algorithms and quer
SQL Server: Grant Permission To A Particular Table4/3/2024 10:47:46 AM. In this article, we will learn how to manage database security in SQL Server by granting permissions to specific tables. Safeguard sensitive data and control access with precise authorization settings
Difference Between Union & Union All In SQL Server 20174/3/2024 9:56:30 AM. In this article, you will learn the nuances between UNION and UNION ALL in SQL Server 2017. While both combine results from multiple queries, UNION removes duplicates, whereas UNION ALL retains them.
Temporary Table in SQL Server4/3/2024 9:41:55 AM. In this article, we will learn about temporary tables in SQL Server, a powerful feature for temporary data storage and manipulation. Master T-SQL techniques for creating and managing temporary tables,
Temporary Table vs Temporary Variable in SQL Server4/3/2024 9:41:39 AM. Temporary tables adhere to transaction boundaries, affected by rollbacks, whereas temporary variables remain unaffected, persisting data despite rollbacks. Illustrated through SQL queries, highlightin
Save Encrypted Password In Database In ASP.NET4/3/2024 9:36:57 AM. In this article, Discover how to enhance security in your ASP.NET application by saving encrypted passwords in the database. Learn the process of encrypting passwords before storing them, ensuring dat
Simple Image or File Import Using T-SQL for SQL Server4/3/2024 8:47:23 AM. The article demonstrates importing image files into SQL Server using T-SQL's OPENROWSET, BULK, and SINGLE_BLOB. It covers basic examples and prerequisites, allowing dynamic file paths and names fo
Database Optimization Technique4/3/2024 5:40:07 AM. Database optimization ensures efficient and performant systems. Techniques like indexing, normalization, and query optimization enhance query performance and overall efficiency.

Topics