Database

database

Great Reads

by ASP.NET Community

IntroductionnAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide

10 Things to Make Your Desktop Database Apps Better

by JasonShort

Here are 10 things to make your desktop database apps better

4db: A Dynamic File-based NoSQL Database for C++

by Michael Sydney Balloni

Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!

A Basic Introduction to Sqoop Import & Export for MySql Table to be Used as Hadoop Distributed File System (HDFS) in Cloudera

by SrikantSahu

This tip gives basic commands to import table from Mysql to Hadoop File system and Import the files from HDFS back to Mysql.

Latest Articles

.NET Application Modeling Language

by ASP.NET Community

IntroductionnAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide

10 Things to Make Your Desktop Database Apps Better

by JasonShort

Here are 10 things to make your desktop database apps better

4db: A Dynamic File-based NoSQL Database for C++

by Michael Sydney Balloni

Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!

A Basic Introduction to Sqoop Import & Export for MySql Table to be Used as Hadoop Distributed File System (HDFS) in Cloudera

by SrikantSahu

This tip gives basic commands to import table from Mysql to Hadoop File system and Import the files from HDFS back to Mysql.

All Articles

top

database

.NET Application Modeling Language

by ASP.NET Community

IntroductionnAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide

4db: A Dynamic File-based NoSQL Database for C++

by Michael Sydney Balloni

Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!

A Coder Interview With Vanessa Hurst

by CodeProject, DBNess

Welcome to our continuing series of Code Project interviews in which we talk to developers about their backgrounds, projects, interests and pet peeves. In this installment we talk to Vanessa Hurst, founder of Developers for Good, co-founder of Girl Develop It!, and a consultant and advisor to startu

A Database Initialiser for SQLite and NPoco

by Private Dobbs

How to initialise a database and then automatically keep it up to date with version releases

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

by Jesus Carroll

SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.

An All purpose database manager

by Menci Lucio

I wrote a class to have an access to all databases in the simplest and smartest way

Android Data Storage

by Varavut

Lean about how to manage the data

Android dynamic Sqlite database management v.2

by Pavel Durov

Article about dynamic Sqlite database management on Android platform using Java class reflection.

Article 8 - Handling Input and Storage on Android

by Ahmed Alaa El-Din

This articles provides a brief description of different methods that Android platform can provide for a developer to save different data types with different storage methods like Shared Preferences, Internal Storage, External Storage, SQLite DB, and Web Services

ASP Repeater Control and Export to Excel

by ASP.NET Community

ASP Repeater ControlThe Repeater control is used to display a repeated list of items that are bound to the control. The Repeater control may

ASP.NET Core cross platform development with Database

by Bruce Yang CL

Develop an ASP.NET Core NES Game website on Linux with cross platform Database, and deploy to Ubuntu & Windows which have no .NET Core runtime installed.

Autogenerate Unit Tests For Your Database Objects - Visual Studio 2019 & 2022 (amd64) Extension

by Bert O Neill

Features and functionalities associated with Autogenerate DB Unit Test app

Automating the SQL Database Mirroring Setup

by Dathuraj Pasarge

Database mirroring setup without any DBA effort - on every new database creation

Basic Handling and Types of Database Relationships in Entity Framework

by Ws Hu

This article tries to fit all levels of readers by covering both basic database concept and practical tips for handling Entity Framework.

Big Data MapReduce Hadoop Scala on Ubuntu Linux by Maven intellj Idea

by Mahsa Hassankashi

This article is the most complete essay about big data from scratch to practical.

Binary Relational Modeling

by Ivan Vodišek

An alternative approach to database modeling.

Binding Grid View Control

by ASP.NET Community

In this article I will sharing how to bind with GridView control with Database and without database using Data Table.Bind GridView with DatabaseI

Build Your Own Database

by nam1234567

Build your own database class library with C#

Bulk Insert a .NET List to Database

by Praveen P R

This article presents a simple and efficient way to bulk insert any .NET list to the database.

C#.NET – Removing Duplicate Records From DataTable

by Noor Ahmad Feroozi

A function to remove and select unique records from a DataTable in C#.NET and return a clean and duplicate-free DataTable

Cachalot DB as a Distributed Cache with Unique Features

by Dan Ionescu (USINESOFT)

LINQ extensions that allow to describe and to safely query cached data

Conditional filtering in SQLAlchemy and Python

by DiponRoy

Conditional filter query example in SQLAlchemy and Python

Configuring SQL Server

by ASP.NET Community

Most ASP.NET sites talk to SQL Server or a backend SQL Database and there's a number of ways to manage that configuration.I always start with the

Create a div based grid functioning on JSON data using MVC with Entity Framework and MySQL

by Rajat Bittharia

Grid based on JSON data using MVC with Entity Framework and MySQL.

Create First SSRS Report with SQL Server Analysis Services OLAP Cube

by Mubin M. Shaikh

This Article will give you a good start for Creating SSRS Report First time with SQL Server Analysis Services OLAP Cube

create LINQ to database in the .NET Compact Framework 3.5

by ASP.NET Community

Let see an example of using the database in LINQ and C#.netcf We will using classCustomer Here'ssome sample

Create OData endpoint for MongoDB on MEAN stack

by Neal Pandey

This article is a tutorial on creating a basic OData (Open Data Protocol) endpoint for a MongoDB database using MEAN stack.

Creating a Custom De/Serializer

by Alaa Ben Fatma

In this article, we will walk through the basic concepts of de/serialization and how to create a very basic de/serializer.

Creating a custom membership provider

by ASP.NET Community

When working with an ASP.NET site that requires some sort of user authentication (almost every time, I'd say), we often need to establish our own

Creating a Full Text Service and Searching items from Code behind

by ASP.NET Community

Open SQL Server and open a database (Already created) . On the Storage section find the Full Text Catalog. Right click and create a New

Creating a Transaction (Enterprise Libraries)

by ASP.NET Community

Following is an example of creating a transaction when require to save on many tables at once. I used Microsoft Enterprise Libraries. I assume one to

Creating Menus with JavaScript, LINQ, and SqlDataAdapter

by ASP.NET Community

Basic Hard Coded Cascading MenusTechnically your menus won't need javascript to be utilized. Just some basic CSS that will help with everything and

Database Export Wizard for ASP.NET and SQL Server

by Olivier_Giulieri

A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL

Database Worst Practices – New Town and New Job and New Disasters

by pinaldave

5 Database Worst Practices which can be fatal to any business

DataProvider - A Static Library for Handling Databases from C++

by Michael Haephrati

A Static Library which can be used for all kinds of database related needs

Developing Automated Data Purge Solution

by DaveAuld

Too much data is breaking the system, we need a fix!

Developing Semantika Client Application

by Josef Hardi

This is the third and final article about Semantika. This article will guide you to develop a simple "hello-world" query application

Dev's User Guide To SqlLocalDb (Sql Express)

by raddevus

Learn the basics (and challenges) of using LocalDb to make your SQL dev easier and localized using tools like SqlLocalDb, sqlcmd and built-in Visual Studio server explorer. Now, also includes SqlCmd scripting.

Displaying Update progress at center of gridview

by ASP.NET Community

In this article I am explaining about how to show Loading... image using Update Progress at center of grid view. for this article i have used North

Documenting MS SQL Server Databases

by Evgeniy Gribkov

The examples of SQL Server database documentation using both the extended properties and a third-party utility.

Dynamically Add Access Database Columns at Runtime using VB.NET

by Rob Culhane

How to dynamically add access database columns at runtime using VB.NET

EF Code First and WPF with the Chinook Database. Part 3 – Styles and DataTemplates 101

by Leom Burke

EF Code First and WPF with the Chinook Database - Styles and DataTemplates

Employee Info Starter Kit - Getting Started

by ASP.NET Community

Employee Info Starter Kit is an open source ASP.NET project template that is intended to address different types of real world challenges faced

Entity Framework 7 – Code First – Using CLI

by Mark Pelf

Tutorial on EF7 – Code First approach using Command Line (CLI)

Entity Framework 7 – Database First – Using CLI

by Mark Pelf

Tutorial on EF7 – Database First approach using Command Line (CLI)

Entity Framework 7 – Database First – Using EFCorePowerTools

by Mark Pelf

Tutorial on EF7 – Database First approach using GUI tools EFCorePowerTools

Entity Framework with nHydrate

by Christopher R Davis, Michael S Knight

Generate an Entity Framework data access layer using an nHydrate model.

Fast External Sort in C#

by Stefan Savev 2

Fast External Sort in C#: sort 30 GB of integers on an external USB drive in one hour

Fast Typo-Insensitive String Matching in a Program and a Database

by David Wincelberg

Strings that differ by typos can be matched.

FlatFile Database System

by Anand Gunasekaran

Working with text file as database can querying as RDBMS with SQL Queries.

Friday the 13th - JSON is Coming to SQL Server

by Jovan Popovic(MSFT)

Overview of built-in support for JSON text processing in new SQL Server

Generated Columns in PostgreSQL

by Shameel

This article describes different ways of setting up generated (computed) columns in different versions of PostgreSQL.

Generic Repository with SQLAlchemy and Python

by DiponRoy

Example of Generic Repository Class with SQLAlchemy and Python

Getting Started with Data Analysis in Azure Synapse Analytics Part 2: SQL Pool

by DaveNoderer

In this article, we explore how to set up one component, an SQL pool.

Getting started with MongoDB

by ASP.NET Community

Getting started with MongoDBMongoDB is a famous representative of NoSQL databases. It is a document-oriented database, which means that data will

Getting Started with PouchDB - Part 1

by Paul D. Sheriff

As more and more users interact with web applications on their mobile devices, it is becoming increasingly important for software developers to allow them to work offline; PouchDB can help.

Getting Started with PouchDB - Part 2

by Paul D. Sheriff

In this 2nd part of my series on PouchDB, you learn how to perform multi-document inserts and reads.

Getting Started with PouchDB - Part 3

by Paul D. Sheriff

In this article, the 3rd in a multi-part series, you are going to learn how to query data within a PouchDB database.

GraphQL: Evolution of Modern Age Database Management System

by David Cuelogic

GraphQL: Evolution of Modern Age Database Management System

Hidden Gems of DEFAULT TRACE in SQL Server

by Sergii Syrovatchenko

Starting from SQL Server 2005, the default trace is enabled by default on every SQL server. Default trace is a lightweight system trace, which stores a lot of useful information about the changes in the system...

How GraphQL Makes Graph Databases Relevant for Full-Stack Developers

by William Lyon

GraphQL APIs, backed by Neo4j – a native graph database – enable complex relationships to be easily modeled, queried, and resolved. That could be a boon for newsrooms where usually nothing comes easily.

How to capture Google Forms responses into a Kintone Database

by Kintone Developer Program

This article introduces how to capture Google Form responses into a Kintone Database, instead of capturing them in a spreadsheet.

How to Create a Relevance Based Search Query for SQL

by Manan J

Arrange Results to get the most relevant result first...

How to create Umbraco database on shared hosting.

by ASP.NET Community

I had to create Umbraco database on my shared hosting (I am using Winhost at the moment) couple of days ago.After checking few examples on

How to do some magic with indexedDB

by David Fahlander

Discover the hidden features of indexedDB!

How to Manipulate Hierarchical Information in Flat Relational Database Tables

by Akshay Srinivasan2

This article describes a technique to quickly retrieve and present hierarchical information from a flat relational database table with only one table scan.

How to Save Object Graph in Master-Detail Relationship with One Stored Procedure

by Vadim Loboda

A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters

How to stop creating the aspnetdb.mdf database

by ASP.NET Community

If you use the asp.net membership providers, having visual studio keep this sql database file around for deployment can sometimes be convenient.

iDb2Connection - How to cancel a long running query

by Dylan Morley

Describes how you can run multiple queries against an iSeries DB2 and cancel long running queries.

Implement a Distributed Database to Your Java Application

by Sam B. Brown

Interference open cluster is a simple Java framework that enables you to run a distributed database service within your Java application

Implementing a CQRS-based Architecture with MVC and Document DB

by Adam Tibi

A typical implementation of a CQRS pattern ASP.NET MVC 4, Ninject and MongoDB. I will be demonstrating a sample applications that acts as a base building block for a CQRS-based architecture.

Indexed Views and How It Can Help in Improving Query Performance

by Minh Tuan Do

A considerable method to speed up query running time

Input, Output and Input/Output SqlParameter Behavior Explained

by Bob Crowley

In this article, I will explain the sometimes surprising behavior of the ADO.NET SqlParameter and particularly the effects of ParameterDirection, null value and DBNull.Value on how the parameter is sent to the database.

Integrate Firebase Phone Authentication With Laravel

by Member 13935194

In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.

Introduction to B-trees: Concepts and Applications

by Ștefan-Mihai MOGA

How to solve real-life problems using B-trees

Iterators and Snapshots for LevelDB UWP

by Zohaib Sibte Hassan

A more detailed look into Iterators and Snapshots in LevelDB UWP

Jatalog: A Datalog Deductive Database in Java

by Werner Stoop

A Java implement of Datalog, a subset of the Prolog programming language that is used as a query language in deductive databases

Kerosene ORM Dynamic Records In Depth

by mbarbac

A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library

Kerosene ORM Maps In Depth

by mbarbac

A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.

Kerosene ORM: a dynamic, configuration-less and self-adaptive ORM for POCO objects supporting a SQL-like syntax from C#

by mbarbac

The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.

LINQ to SQL Relationships

by ASP.NET Community

LINQ to SQL is an interesting Object-Relational Mapper because it remembers the relationships objects have between each other. As usual, LINQ to SQL

LiteDB - A .NET NoSQL Document Store in a Single Data File

by Mauricio David

Simple, fast and free embedded .NET NoSQL Document Store in single data file

LiteDB - A .NET NoSQL Document Store in a Single Data File

by Terence Wallace

Alternative VB.NET version of "LiteDB - A .NET NoSQL Document Store in a single data file"

Locks and Duration of Transactions in MS SQL Server

by Manjuke Fernando

Locks and duration of transactions in SQL Server

Manage Entity Framework Code First in Real Time Projects

by DiponRoy

How to manage Entity Framework Code First in Real Time Projects

Manage SQL Server Database

by Pranay Rana

Manage SQL Server Database within Visual Studio Team System

Masking Sensitive Data with SQL Server 2016

by Suvendu Shekhar Giri

How sensitive data in SQL Server 2016 can be masked from the outer world using Dynamic Data Masking

Merge Data in Database

by DiponRoy

How to use MERGE statements in different databases

metastrings: A Simple File-based Dynamic NoSQL Database

by Michael Sydney Balloni

Learn about the inner workings of a dynamic database, and how SQLite is a great fit

Microsoft Access Application Development Guidelines

by Marco Sorich

Some guidelines for developing better MS Access solutions.

Model-driven REST or GraphQL API for CRUD and More

by Olivier_Giulieri

Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL

Mongo DB Tutorial and Mapping of SQL and Mongo DB Query

by VijayRana

A tutorial for MongoDB Tutorial

MongoDB Installation Scripts for Windows

by x3F

Batch scripts that help install MongoDB on a Windows PC

MongoDB Tutorial - Day 2

by VijayRana

MongoDB Tutorial - MongoDB specific queries

MongoDB Tutorial - Day 3 (Performance - Indexing)

by VijayRana

Performance - Indexing in MongoDB

MongoDB Tutorial Day 4: Aggregation

by VijayRana

Aggregation in MongoDB

MySQL Auto Failover using Keepalived on CentOS

by Renz Ladroma

A tutorial on how to setup Keepalived for MySQL Auto Failover

NodeJS REST server trials to validate effective scripting

by Jason Rudland

Trial of popular REST implimentations for NodeJS including the measuring of MongoDB insertion rates.

NoSQL: MongoDB for Beginners

by adityaswami89

NoSQL: MongoDB for beginners

NoSqlJsonFile - .NET lightweight Document Store

by PraiseTheSun

A NoSQL-like document store in JSON format.

Notifying Slack channels with Process Management statuses

by Kintone Developer Program

This article introduces how to utilize Slack’s Incoming Webhook feature, to post messages into Slack channels when a workflow status of a record in a Kintone App is proceeded to "Completed".

One to Zero/One Relation in Entity Framework Code First

by DiponRoy

Here, we will see how to configure one to zero/one relation between two entities in Entity Framework Code First

Options for Database Backup and Restore - How to Export BACPAC using SSMS?

by Satya Karki

This article describes the options to restore and backup database in SQL Server and explains how to Export BACPAC from SQL Server Management Studio.

Parameterize Schema Name in SSDT Database Project .dacpac file by using DacFx Public Model and System.Reflection

by Pavel Sinkevich

How to programmatically change schema name in database project before deployment

Performance testing of ORM layers in Python and C++

by Vaclav Naydenov

Comparing the performance of two similar CRUD server apps, one written in Python and SQLAlchemy, the other in C++ and YB.ORM.

Provider Factory

by ASP.NET Community

Providers factory provides us indepandent database access where we can connect to any database sources(SQLServer,DB2,Oracle,MS-Access).Provider

Quick Introduction to YB.ORM - Object Relational Mapper for C++

by Vaclav Naydenov

How C++ library YB.ORM can help manipulate the data stored in RDBMS using domain classes. Basic concepts of ORM are explained by examples.

QxOrm - C++ ORM (Object Relational Mapping) Library

by QxOrm

QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)

RadioButtonList

by ASP.NET Community

A RadioButtonList can be used to select 1 option within several options. The item "Pizza with egg" is selected by default. <asp:RadioButtonList

RaptorDB - The Key Value Store V2

by Mehdi Gholam

Even faster Key/Value store nosql embedded database engine utilizing the new MGIndex data structure with MurMur2 Hashing and WAH Bitmap indexes for duplicates. (with MonoDroid support)

Realtime MVC Application using n-tier architecture

by Sandeep Neela

Refering dlls in SSIS Script Task

by Rajeesh Madambat

Refer and write your own business logic in C# and add it to SSIS script task.

Relative Constraints and Permissioning in T-SQL

by h_wiedey

Implementation of relative database constraints and permissioning using triggers and shadow tables.

Restrict Access to SQL Server Data using a Facade Database

by Shameel

This article describes a way to create a Facade Database to provide restricted access to specific tables in your databases to specific users without granting direct access to any of the underlying databases/tables.

Saving and Calling a image from SQL Server DB

by ASP.NET Community

DAL Should like following when inserting a image. I used the Enterprise Library to data access. Data type of EmployerImage is image @ SQL Server

Saving Records & Caputring Return Value (Enterprise Library)

by ASP.NET Community

Stored Procedure should look like thisCREATE PROCEDURE [dbo].[Purchases_Insert] (@SupplierID bigint, @ReferenceNo NVARCHAR(20),

Self-Synchronized Data Access Layer - Part II

by Aydin Homay

In the software implementing business synchronizing structures/templates of the database entities with Data Access Layer SQL (commands/Transactions) is the most expensive thinks because you need to re-implement when you have change/s in your entities structure's such as Data-type, Name, and etc.

Semantic Database: Concept, Architecture and Implementation

by Marc Clifton

No word has a value that can be identified independently of what else is in its vicinity.

Service for StackExchange: Implementing a Data Provider

by Shuqian Ying

Client side data provider for data importing to a relational data service build for StackExchange data dump.

Simplifying Data Access in ASP.NET MVC WebAPI with Class Library and Entity Framework

by Zohaib Waqar

Simplifying data access using class libraries and Entity Framework without the need for a .edmx file (ADO.NET)

Single Database for Multiple Microservices with FluentMigrator

by Ivan Yakimov

How to use single database to store information from several microservices with the help of FluentMigrator

SPL: a database language featuring easy writing and fast running

by Jerry Cruise

Innovations against the shortcomings of SQL have been made to SPL. SPL redefines and extends many operations of structured data, specifically, it adds the discreteness, enhances ordered computation, implements a thorough set orientation, supports object references, and advocates stepwise operation.

SQL 2017 - New Features

by koolprasad2003

SQL 2017 new features

SQL 2019 - New Features

by koolprasad2003

New features of SQL 2019

SQL Database Simulator in the Browser

by Avron Polakow

This article presents a client-side, JavaScript Relational Database Simulator in the browser, using SQL commands to Create, Read, Insert, Update and Delete in-browser table data, as well as formatting the output as HTML objects in a Webpage.

SQL Object Dependencies with Simple RegEx and Some Algo Magic

by ASkaeff

A simple yet powerful tool to analyze SQL object dependencies in quite a fast and reliable manner.

SQL Queries to Manage Hierarchical or Parent-child Relational Rows in SQL Server

by DiponRoy

Some queries to find generation of each row, all possible children, all possible parents, managing recursion

SQL Server Database :: Source Control, Continuous Integration and Continuous Deployment using Github, TeamCity and Octopus

by Ravi K. Acharya

The complete step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus.

SQL Server Express LocalDB

by ASP.NET Community

For ASP.NET developers, there is good news from Microsoft with the latest SQL Server release, Denali CTP3.Many developers like ASP.NET developers

SQL Server Notifications on Record Change with SignalR and SQLTableDependency

by Christian Del Bianco

SqlTableDependency is a component used to receive database notifications containing the record values inserted, deleted or update on a database table.

SQL Simple Utilities

by Alexandros Pappas

This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.

SQL-File Technology for Transact-SQL

by Sergei Y.Kitáev

Introduction to statically parameterized SQL language

SqlServer & EF7: Using datetime vs datetime2 date type

by Mark Pelf

Showing problems with limited accuracy of SqlServer data type “datetime” in .NET7 EF7 environment

Step-by-Step PHP Tutorials for Beginners - Creating your PHP Program FROM SCRATCH: Basic Authentication, Membership and CRUD Functionalities

by Kristian Guevara

PHP tutorials for beginners

String Aggregation in the World of SQL Server

by Sergii Syrovatchenko

This article includes examples of T-SQL capabilities that allow to perform string concatenation flexibly and effectively through the use of different constructs.

That's not a database, dude!

by OriginalGriff

There are many things you can use to store information, but not all of them are databases. And trying to use them as such is a really, really bad idea.

The Data Tune System

by Michael Haephrati

The DataTune system was one of the earliest data cleansing systems.

THVDataSet - A Complete Delphi DataSet Based on Stream

by hamdenvogel

Learn how to implement a real stream file based dataset descendant with blob support and much more

Top 10 Exciting New Features in SQL Server Management Studio 2016

by Suvendu Shekhar Giri

Introduction of new useful features in SSMS 2016

T-SQL reporting engine

by Levente Kupás

If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.

Unattended installation of SQL Server 2012

by Jesus Carroll

Despite the references of several sources of unattended installation of Microsoft SQL Server Database Engine, in this article describes a script tested in real production environments and it can be used with minimal or - perhaps - no modifications.

Understanding Complex MySQL JOIN

by Vijay-Srivastava

Fetching complex data from multiple table using nested MySQL queries, JOIN operations, LIKE operator and aggregate functions(eg. GROUP BY, GROUP_CONCAT, etc.)

Understanding Vector Databases

by Nicolas DESCARTES

What are vector databases?

Upload an Image and an Audio file using C#

by ASP.NET Community

In my case, I use a FileUpload Control(Id:->FileUpload1), an ImageButton(ImageButton1) or you can use the Image, a Button Control(Id:->Updatebttn)

Uploading files to database from ASP.NET pages

by ASP.NET Community

This example will show how is possible to upload files to SQL server database using C# and asp.net. For demostration purposes database will have only

Using Redis for Storing and Working with Geospatial Data

by Aleksandr Ulanov

Learn how to use Redis and its geospatial indexes and commands for complex geo calculations

Using WCF REST HTTP to call Stored Procedures on SQL Server

by Tom Glick Philadelphia, US

Using WCF REST Service to call Stored Procedures and run queries on SQL Server.

Visual Basic Using Reflection to Map DataTable in MySQL Database

by Mr. xieguigang 谢桂纲

Easy way to map the table in the mysql database.

Visual Studio LightSwitch Application Database Script Generator

by Jaganathan Bantheswaran

A tool to generate SQL server DB script from the LightSwitch internal database

Why a Graph Database Solves Problems Other Databases Won’t

by Jason_Koo

In this article we look at why when store and query data using a graph database such as Neo4j, you can quickly surface critical information, and possibly expose potentially catastrophic issues hidden within complex datasets.

Wizard and CRUD Applications to Build other CRUD Applications

by Olivier_Giulieri

Looking at the possibility of using CRUD applications to manage other CRUD applications inside a web browser and without any hand-coding. Also, presenting a step wizard deriving the database structure from the UI rather than the opposite.

Workaround for AT TIME ZONE Performance Issues in SQL Server Views & Dynamic SQL

by Andriy Protskiv

Workaround for performance issues with AT TIME ZONE