.NET news » Database 
The Working Programmer: Cassandra NoSQL Database, Part 3: Clustering
Talk about big data, this database can scale to “ridiculous” sizes, says Ted Neward. One firm claimed to use Cassandra to store more than 50PB of information. Learn how clustering makes such implementations possible straight out of the box.
31 Oct 2012, 18:00:00 Source: The Working Programmer: Cassandra NoSQL Database, Part 3:...
Tags: Database
Async database polling with EntityFramework 5
How to asynchronously poll a database for an Entity with EntityFramework 5
The Baker’s Dozen Doubleheader: 26 Productivity Tips for Optimizing SQL Server Queries (Part 2 of 2)
In part two of this series on optimizing SQL Server queries I’m going to continue with some T-SQL scenarios that pit one approach versus another. I’ll also look at what SQL developers can do to optimize certain data access scenarios. I’ll also compare approaches with temporary tables versus table variables, and stored procedures versus views.
The Working Programmer: Cassandra NoSQL Database, Part 2: Programming
Ted Neward explains how to connect to the Apache Cassandra NoSQL database from the Microsoft .NET Framework, how to read and write data to it, and more.
30 Sep 2012, 18:00:00 Source: The Working Programmer: Cassandra NoSQL Database, Part 2:...
Tags: Database
Dynamically Map SQL Resultset to Business Object
Dynamically map a DataTable to type-safe business objects using reflection and generics.
Generating menu from database according to user privilege
Dynamic menu generation according to user privileges from database.
25 Sep 2012, 12:58:00 Source: Generating menu from database according to user privilege
Tags: Database
MySqlBackup.NET - MySQL Backup Solution for C#, VB.NET, ASP.NET
Unicode, UTF8 character backup and restore of MySQL database in C#, VB.NET, ASP.NET
25 Aug 2012, 10:55:00 Source: MySqlBackup.NET - MySQL Backup Solution for C#, VB.NET,...
Tags: Database
Using Spatial Data with SQL Server 2012, Entity Framework 5 and ASP.NET MVC
One of the highly-anticipated features in the Entity Framework 5 is a Spatial support.
The Working Programmer: Cassandra NoSQL Database: Getting Started
Ted Neward explores Cassandra (the NoSQL database software, not the figure from Greek mythology), which is “an open-source, distributed, decentralized, elastically scalable, highly-available, fault-tolerant, tuneably consistent, column-oriented database that bases its distribution design on Amazon’s Dynamo and its data model on Google’s Bigtable.”
31 Jul 2012, 18:00:00 Source: The Working Programmer: Cassandra NoSQL Database: Getting...
Tags: Database
Pitfalls and Pointers for a Base Logging Class in EF Models
An unfortunate use of a base class to provide logging data for all classes in an Entity Data Model creates chaos in the database. Learn why this happens and how to avoid the problem.
31 Jul 2012, 18:00:00 Source: Pitfalls and Pointers for a Base Logging Class in EF Models
Tags: Database