Loading
Getting Started With MongoDB and ASP.Net
This article shows how to install MongoDB in Windows and communicate using ASP.NET. We will create a simple ASP.NET application that retrieves data from MongoDB.
Evolution Of Microsoft Data Access Technologies
This article beams on how Microsoft data access technologies evolved over the period of time.
Object Relational Mapping (ORM) Using NHibernate - Part 5 - A of 8
This is Part 5A of the article series, which concentrates on Many-to-Many Entity Association with a commonly used example but the model and code is a little different.
Database Normalization
Learn the purpose of database normalization and how first, second, and third normal forms reduce redundancy and organize relational data.
What is a Hierarchical Database
Learn how hierarchical databases organize records in tree structures, including parent-child relationships, examples, history, advantages, disadvantages, and IBM IMS.
Step-by-step Create CLR Stored Procedure
In this article we will create a CLR stored procedure step by step.
Understanding Normalization in Database Design
This article is intended to the audiences who are aware of designing the database but are not sure about the Normalization process.
Install MySQL Connector in Visual Studio 2012
This article shows you how to install the MySQL Connector, create a MySQL database and check the MySQL version.
How To Import Large SQL Database Files Into MySQL Using Command Line
In this article you will learn how to Import large SQL Database Files into MySQL using Command Line.
What is a Relational Database (RDBMS)
Relational databases represent data in a tabular form consisting of rows and columns. In this article, we'll learn the basics of relational database management systems (RDBMS) and how data is represented and stored in a relational database.
Basics Of Database With Real Life Example
The basics of databases refer to fundamental concepts and principles that underpin the design, organization, and management of data in computer systems. Databases are essential components in modern computing and play a crucial role in storing, retrieving, and managing vast amounts of structured and unstructured data. Here's a brief description of the basics of databases
ElasticSearch With a REST API
In this article we will learn about ElasticSearch, an Open Source Search Engine with a REST API for querying written words.
Aggregation Pipeline In MongoDB
In this article, you will learn about Aggregation Pipeline in MongoDB.
What Is A Document Database
A document database is a NoSQL database. This article explains what a document Db is and what are the most popular document databases.
Object Relational Mapping (ORM) Using NHibernate - Part 7 of 8
In this seventh article and its client code, we will demonstrate that the classes we have put forth to incorporate the shipping functionality will allow shipment items of an order to be shipped in parts by multiple shipping services.
What Are NoSQL Databases
NoSQL databases are the databases that do not use SQL as their primary data access language. Graph database, network database, object database, and document databases are common NoSQL databases. This article answers the question: What is a NoSQL database?
What Is A Column Store Database
Column Store Databases store the data in columns rather than rows. In this article, let's understand what column databases are and what are the most popular column store DBMS.
What Is Local Disk Storage?
Local disk storage refers to the process of storing data on physical storage devices directly attached to a computer or server. These devices are typically referred to as hard disk drives (HDDs) or solid-state drives (SSDs). Local disk storage is one of the most common methods of data storage in personal computers, laptops, and servers.
Introduction To DBMS
A Database Management System (DBMS) is a software tool that enables users to create, manipulate, and manage databases. It acts as an intermediary between the user and the database, providing an organized and efficient way to store, retrieve, and modify data. DBMS allows users to define the data structure, set up relationships between data elements, and control access to the data. It plays a crucial role in modern data-driven applications, providing a secure and scalable platform for data storage and retrieval. Understanding the basics of DBMS is essential for anyone involved in working with data, whether as a developer, data analyst, or database administrator.
Ecommerce Database Design
E-commerce database design plays a pivotal role in the successful operation of online businesses. One of the core components of such a database is the Product table, which holds paramount importance in the entire system. The Product table serves as the central repository for all essential information related to the products available for sale on the e-commerce website.
MVC Application With MongoDB - Part 2
In this article, we are going to perform CRUD operations in MVC using function prototype of MongoDB.
MVC Application With MongoDB - Part 1
In this article, you will learn about MongbDB server setup, how to start mongoDB server, make connection to server & create application database in MongoDB server using MVC.
Code First Approach With Stored Procedure
This article shows how to access a SQL Server database with the Entity Framework Code First approach and how to create a procedure using the Fluent API.
Uploading Files To Snowflake Stage Using SnowSQL
SnowSQL is a command-line client provided by Snowflake, a cloud-based data warehousing platform. It allows you to interact with Snowflake and execute SQL commands from your local machine. One of its useful features is the ability to upload files to a Snowflake stage, which is an intermediate location where data can be stored before loading it into a Snowflake table.
What Is Network-Attached Storage?
Network-Attached Storage (NAS) is a specialized file-level data storage device that is connected to a computer network, providing centralized data storage and file sharing functionalities. NAS systems are designed to be accessed over a network, such as a local area network (LAN) or a wide area network (WAN), and they typically operate as a file server for multiple clients or users.
Object Relational Mapping (ORM) Using NHibernate - Part 6 of 8
We will discuss one of four ways of mapping inheritance hierarchies in Nhibernate; the way which gives maximum support for inheritance and polymorphism (the main benefit of capturing an inheritance heirarchy). This is called Table Per Subclass.
How to Retrieve Data From MYSQL Database in C#
Install MySQL Connector/NET: Before you start, make sure you have MySQL Connector/NET installed in your C# project. You can download it from the MySQL website or use NuGet to install the package.
Object Relational Mapping (ORM) Using NHibernate: Part 5 - B of 8
The idea here is to apply the Many-To-Many entity association in the E-Commerce scenario used, for example, throughout this article series.
Object Relational Mapping (ORM) Using NHibernate - Part 4 of 8
Here in this article the intent is to eliminate the nulls introduced in the database by correctly mapping the association between PaymentApprovedOrder and Item as optional One-To-Many.
Object Relational Mapping (ORM) Using NHibernate - Part 2 of 8
Object-Relational Mapping (ORM) is a programming technique that allows developers to interact with a relational database using object-oriented programming paradigms. It bridges the gap between the object-oriented domain model used in application code and the relational database model used for data storage. ORM frameworks like NHibernate facilitate the mapping between objects and database tables, automating much of the data access and manipulation processes.
