This article presents the techniques and caveats of building Silverlight applications that can be notified about database state changes via polling duplex. WSHttp binding and CLR triggers are used to implement the solution as well.

SQL

C#3.0

Windows

.NET3.5

On the fly Code Generation with Evolutility

11 Jun 2010 by Evoluteur

A generic Web User Interface for CRUD applications generating all screens at run-time based on external metadata. It comes with sample applications for address book, memo pad, to do list, restaurants list, wine cellar, and database structure documentation that are easily customizable.

The alxBase classes for work with DBF files

5 Nov 2002 by Alexey

The alxBase classes for work with dbf files.

Client Side Multi-Column Dynamic Pivot

15 Jul 2014 by Jesús López Méndez

This article introduces you to client side multi-column dynamic pivot, a cleaner, simpler and elegant alternative to the complex and convoluted dynamic server side pivot.

SQL

Windows

ADO.NET

Hadoop For .Net & AngularJS Developers

29 Dec 2015 by Bert O Neill

Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

Javascript

.NET-Compiler-Platform

Master Chef (Part 1) ASP.NET Core MVC with Fluent NHibernate and AngularJS

6 Feb 2020 by Fred Song (Melbourne)

In this article, I want to show how to build a Single Page Application – MasterChef with ASP.NET Core MVC, Fluent Hibernate, and Angular JS.

CRM Customization - Import Leads from Excel via Email into MS CRM

6 Sep 2007 by aleksisa

Build a process to import Leads records from Excel into MS CRM via email.

Rename a Database and its MDF and LDF files in SQL Server

13 Mar 2012 by Tecfield

This tip shows how to rename a database and its MDF and LDF files in SQL Server.

Difference between delete and truncate

22 Apr 2012 by parul77

DELETE1. DELETE is a DML Command.2. DELETE statement is executed using a row lock, each row in the table is locked for deletion.3. We can specify filters in where clause4. It deletes specified data if where condition exists.5. Delete activates a trigger because the operation are logged...

SQL

PaydayUSA™ Employment Tax Calculator and Payroll Organizer

17 Feb 2015 by DrABELL

Employment Tax computation and Payroll management app for Windows 8: contest entry

Update Multiple Rows of GridView using JSON in ASP.NET

20 Jun 2014 by Debabrata_Das

This article will talk about how to update multiple records in a GridView on a single button click using JSON in ASP.NET

Autosuggest TextBox from database column in Windows Forms

19 Apr 2012 by Deepak_Sharma_

This article will show how to create an auto-suggest TextBox that will suggest data from a SQL Server database column.

Brief Introduction of a Continuous SQL-stream Sending and Processing System (Part 1: SQLite)

1 Jan 2021 by Yuancai (Charlie) Ye

Application of SocketPro onto various databases for continuous inline request/result batching and real-time stream processing with bi-directional asynchronous data transferring

SQL Server Express Edition on Steroids

13 Mar 2021 by Sergii Syrovatchenko

How to omit many restrictions on SQL Server Express Edition

Building WPF Applications with Self-Tracking Entity Generator and Visual Studio 2012 - Project Setup

17 Mar 2013 by Weidong Shen

This article describes the project setup of building a WPF sample application with Self-Tracking Entity Generator and Visual Studio 2012.

Maths in IT #2: Venn diagrams

9 Nov 2015 by Sander Rossel

Using Venn diagrams to visualize sets.

SPA^2 using ASP.NET Core 1.1 + Angular 2.4 - Part 5

16 Mar 2017 by Robert_Dyball

Create a simple data grid that provides list, add, edit and delete and uses a simple 'parent/child' template to provide view, edit or add functionality

A PostgreSQL Notification Example

15 Oct 2020 by RickZeeland

PostgreSQL notifications Windows Forms application

MsSql.RestApi - The Easiest Way to Build the ASP.NET REST API

5 Nov 2018 by Jovan Popovic(MSFT)

Create powerful REST API with just few lines of C# code using MsSql.RestApi package

Computed Columns - Index and Performance

24 Aug 2010 by pinaldave

A Finale of Series discussing Computed Columns, Storage and Performance

SQL

SQL Server Governor: The unknown hero

7 Sep 2012 by Shivprasad koirala

This article will discuss about SQL Server governer.

The Product Aggregate in T-SQL Versus the CLR

22 Feb 2013 by Scott Burkow

An exercise in algorithm analysis and design.

Dynamically Add Access Database Columns at Runtime using VB.NET

21 Apr 2013 by Rob Culhane

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

Monitor Database Changes

21 Oct 2013 by Member 7874525

This how you can monitor your database changes

WPF SQL Replication Tool (Part 2)

12 Nov 2015 by Fred Song (Melbourne)

In this article, we started from Generate Inserts procedure, then go through how generates inserts SQL files with this procedure and runs these inserts SQL files to import data.

Working with MongoDB's $lookup Aggregator

21 Jun 2016 by Marc Clifton

A deep dive into the $lookup aggregator with examples of one-to-one, one-to-many, many-to-many, and nested relational "queries"

Formatters and Content Negotiation in ASP.NET Web API 2

5 Jul 2016 by Akhil Mittal

This article will focus on practical aspects of formatters and content negotiation in ASP.NET Web API

Combination of Id-ParentId and HierarchyId Approaches to Hierarchical Data

17 Jul 2017 by Vadim Loboda

Combine Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order

SQL

VS2015

SQL-Server

The Oracle Call Interface (OCI) and ODP.Net - Part 1

23 Mar 2021 by Espen Harlinn

Proven techniques for fast Oracle Database access using .NET 5.0 and native C++

Asynchronous T-SQL Execution Without Service Broker

15 Sep 2008 by Oleg Vorkunov

Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.

Learn Docker by building a Microservice

19 Apr 2016 by Dave Kerr

If you are looking to get your hands dirty and learn all about Docker, then look no further!

SQL

Node.js

docker

5 Jul 2021 by gggustafson

This article provides the code necessary to implement a website login mechanism without using third-party software.

SQL

Javascript

PHP

DACBuilder – Data Access objects generation tool based on XML and XSL templates transformation

31 Mar 2006 by Dan Radu

The DACBuilder application provides auto-generation features from multiple database systems in multiple programming languages.

Setting up an MS Outlook Appointment C#

28 May 2010 by DecodedSolutions.co.uk

This is a simple article describing how to create an add an outlook appointment to your MS Outlook Calender.

Dynamically Pointing to Shared Data Sources on SQL Reporting Services using a Report Definition Customization Extension (RDCE)

27 Mar 2012 by Carlos Alberto Cabrera Gonzalez

This article shows a detailed approach on how to dynamically point to a given shared data source reference by setting up an RDCE and using a couple of tips and tricks.

Linking to an Existing SQLDB in ASP MVC4.0 and EF5.x

20 Nov 2012 by SEJohnson

Linking to an existing SQLDB in ASP MVC4.0 and EF5.x.

SQL

MVC4

Ask Your Database for that Unique ID

2 Sep 2015 by Peter Leow

Get your database to generate unique running IDs for your application

SQL

MySQL

PHP

Aggregation in MongoDB

27 Oct 2016 by Vikas Sharma

In this article, we will focus on aggregation pipeline. I'll try to cover each major section of it using simple examples. We will be writing mongo shell commands to perform aggregation.

SQL

MongoDB

NoSQL

Copy/Synchronize Table Data between databases

16 Mar 2012 by Anurag Gandhi

A Query to copy an individual table data between databases

Database script execution with test

3 Feb 2013 by S. M. Ahasan Habib

Database script execution with testing

Email Search Engine

11 Jan 2015 by SarmadAsghar

Building on My SQL Storage Engines and APIs to Conduct Complex Analysis Using SQL Query Language: Part 5

Debug ASP.NET MVC Application with Glimpse

11 Jan 2015 by Muhammad Hassan Tariq

Glimpse Extension for server side debugging and diagnostic information of ASP.NET applications

Angular Single-Page Applications - Cool Privilege Control System

29 Mar 2016 by wells cheung

Angular Single-Page Application, MEF, Privilege Control, WCF Restful Service, ui-router,

Insert Multiples Records to SQL Server Database

15 Mar 2017 by Ricardo_Torres_Torres

Read text file and insert mutiples records in just one SQL Sentence

WPF Disabled Items Behaviour

6 Aug 2016 by Clifford Nelson

This tip presents a way to have disabled items in your ComboBox

LINQ to Entities, Cross Apply, and Left Outer Join

12 May 2017 by DaveDavidson

In this article, I show LINQ to Entities syntax that will produce queries with CROSS APPLY and LEFT OUTER JOIN clauses.

Introduction to NoSQL and Polyglot Persistence

16 Oct 2017 by Nikola M. Živković

Introduction to NoSQL and Polyglot Persistence

SQL

NoSQL

database

Brief Introduction of a Continuous SQL-stream Sending and Processing System (Part 2: MySQL)

4 Apr 2021 by Yuancai (Charlie) Ye

Continuous SQL-stream Sending and Processing System

SQLXAgent - Jobs for SQL Express - Part 1 of 6

27 Feb 2018 by #realJSOP

Create and run jobs kinda like SQL Server Enterprise - Users Guide

Dockerize A Simple Web-Application Created By Using Python, Flask and PostgreSQL

24 Aug 2018 by Arthur V. Ratz

Create a Python web-app using Flask and PostgreSQL server, and run it in Docker

Writing into a File from Database

4 Nov 2016 by Wendelius

Few CLR procedure concepts to write into a file from SQL Server database

The CODBCDynamic class

14 Mar 2000 by Tom Archer

A class to dynamically read data from any ODBC data source

Automatic Script SQL Server 2005 Objects and Commit under Subversion

9 Oct 2009 by Ferreri Gabriele (Megasoft78)

Automatic script SQL Server 2005 objects and commit under Subversion

Read a file using transact-sql.

8 Jul 2010 by Md. Marufuzzaman

How easy to read a file without using of the seven extended stored procedures.

How to Insert Data Using SQL Views Created Using Multiple Tables

5 Aug 2011 by Manjuke Fernando

This post will show you how to insert data using SQL views created using multiple tables.

SQL

CourseLearner: Azure based E-Learning product

9 Jun 2013 by Ravi Gadag

Azure based e-learning product.

Passing Object Collections to ASP.NET Web API

16 Jan 2014 by Tom Glick Philadelphia, US

POC to demonstrate passing of collections of complex objects to ASP.NET Web API Controllers.

Are Using Bitwise Operators for Table Joins Really Taboo?

26 Jul 2017 by Ed Wiebe

Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?

Why Would You Use Common Table Expressions?

10 Apr 2018 by Gaston Verelst

Why you would use Common Table Expressions

ASP.NET Gridview in Web Forms using Bootstrap 4

30 Jul 2019 by Don Hoang

This post describes implementing ASP.NET Gridview using Bootstrap 4.

Database for financial accounting application IV: General Purpose Documents & Fixed assets

18 Sep 2019 by Niemand25

Designing a simple yet functional database for financial accounting application.

SQL Server: Query to find upcoming birthdays for the current week

13 Sep 2012 by Wendelius

This is an alternative for "SQL Server: Query to find upcoming birthdays for the current week"

CODBCAccess: a CDatabase and CRecordset Wrapper

12 Mar 2003 by Alexander Wiseman

A class to wrap the use of CDatabase and CRecordset into one object to communicate with databases

Add "Select All" to parameter lists in SQL Reporting

9 Mar 2005 by Sven Cipido

How to add a "select all" option to your parameter lists in SQL Reporting.

Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 4

27 Jul 2009 by Paul Rony

Programmer's Guide to Starting a Software Company and Building an Enterprise Application

Creating a SQL Server Database Programmatically

14 Aug 2010 by Roger Wright

A simple example of creating a new database on a SQl Server instance

SQL

SQL-Server

Aggregate Product function extends SQL

19 Feb 2015 by DrABELL

Technique to extend capability of standard SQL by adding the Aggregate Product Function

How to check if value exists in database,

17 Jan 2011 by Shahin Khorshidnia

Hi,Make a stored procedure in SQL Server for example:Create Procedure FindString(@MyString nvarchar(50))AsBegin Select * From MyTable Where Value = @MyStringEndMake a Class in .NET For example :public class ReadData{ public bool FindString(string...

SQL

A Palindrome Program in SSIS using Copy Column, Derived Column, Character Map and Conditional Split Transformation

27 Apr 2011 by Niladri_Biswas

This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.

SQL Bulk copy method to insert large amount of data to the sql database

3 Jan 2012 by bluesathish

Fastest and most efficient method to insert large amount of records to a SQL Server database from our system generated datatable.

SQL

Configuring SQL Server Accent-Insensitivity

21 Feb 2012 by Daniel Miller

This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.

Using FluentMigrator with MSBuild

12 Jun 2012 by Miroslav Popovic

MSBuild database migrations/upgrades with backup and restore functionality

How to Fix Orphaned SQL Users

26 May 2013 by Tharaka MTR

This post will show you how to fix orphaned SQL users.

Using Table variable instead of Cursor Variable

3 Nov 2013 by S. M. Ahasan Habib

I will explain here how to use table variable and over come cursor limitation

CRUD Operations with ASP.NET Web API using FluentNHibernate, Repository Pattern

16 Oct 2014 by Gaurav Aroraa

In this step-by-step article, we will discuss all about CRUD (Create Read Update Delete) operations with Web API using Repository pattern.

Generate SPA Web App Instantly in Minutes

22 Oct 2014 by Kalvin Lawrence Ernst

Generate a web app instantly, directly from a database(SQL Server)

Get Ready to Learn SQL: 8. Database Normalization Explained in Simple English

22 Oct 2014 by essentialSQL

Database normalization in SQL explained in simple English

SQL

normalization

database

Entity Framework Dynamic Report

5 Sep 2015 by Maxim Kurayan

EF Dynamic Report is a small open source project which allows you to use Entity Framework mapping between types and tables as a dynamic report data source

Reset SQL Server SA (System Admin) Password

21 Sep 2015 by Sarathi Balakrishnan

Reset SQL server SA (System Admin) Password when you have lost all possible ways to connect to SQL server and your server has only Windows authentication disabled. You should have Windows administrator permission to do this.

SQL

SQL-Server-2012

DBA

WPF SQL Replication Tool (Part 1)

4 Nov 2015 by Fred Song (Melbourne)

Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.

Remove Duplicate Rows with CTE

14 Aug 2017 by Ehtesam Ahmed

This article gives you quick tip about how you can remove duplicate rows easily using common table expression in SQL

SQL

Mission Impossible: Migrating .NET Core 1.x to 2.0

19 Aug 2017 by Afzaal Ahmad Zeeshan

.NET Core 2.0 brings a lot of improvements to the system, and it brings a lot of pain to the developers as well. I had a lot of problems upgrading .NET Core 1.x apps to .NET Core 2.0; I yet have to feel the promise it makes about performance and so, but let us see how to upgrade our existing applica

SQL Database Access

18 Mar 2019 by Martin Vorbrodt

SQL database access

Simplifying Dynamic SQL Queries with Dapper

U 16 Apr 2024 by Mishael Ogo

A look at a simple SQL builder for Dapper

SQL

.NET

dapper

Persisted Permutations

4 May 2004 by Daniel Aioanei, Adi Malinaru, Andrei Postolache

An article on how to persist permutations of items in relational databases.

Retrieving and Storing Call History

19 Dec 2007 by Bryan Sachdeva

This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.

how to insert new record in my table if not exists?sql server 2005

27 Feb 2011 by _Ashish

Yout Sql command is Incorrect , Insert Command doesn't have Where clause.Where Clause is applicable to Update, Select and Delete Commandsinsert into tablename (code) values ('1448523')WHERE not exists(select * from tablename where code='1448523') --incorrect in insert...

SQL

Apptitude Questions on DOTNET

2 Jul 2011 by thatraja

Here you goAptitude Questions[^]Aptitude Test Interview Questions[^]I found these in CPAsp.Net Interview Question Part 1[^]Asp.Net Interview Question Part 3[^]Ado Dot Net Interview Question Part 1[^]ADO.Net Interview Question Part 2[^]Ajax Quick Start FAQ [^]SOA Interview...

SQL

ASP.NET

TexasQuest v.2.0

22 Mar 2013 by Terence Wallace

TexasQuest is a 2D side scroller platform game similiar to Super Mario

MyMDb your local IMDB store

22 Jul 2013 by Paw Jershauge

Want your own movie database??? Download IMDB in 20 minutes.

Verifying Database Design Issues Against Predefined Quality Rules Using Schema Views

6 Dec 2016 by _Asif_

This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.

Cool Privilege Control System Part 2 -- asp.net MVC with WCF

29 Feb 2016 by wells cheung