You can find all my .Net core posts here. I am adding a new post after a long break because I recently joined a new company called Attach...
Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts
Saturday, August 18, 2018
Creating Multiple Masked Databases with SQL Provision
Sometimes developer teams need access to a copy of the database containing live data. However, if that database contains sensitive or per...
Tuning InnoDB Primary Keys
The choice of good InnoDB primary keys is a critical performance tuning decision. This post will guide you through the steps of choosing ...
Wednesday, January 9, 2013
Understanding SQL Injection and Creating SQL Injection Proof ASP.NET Applications
As ASP.NET developers, we often write dynamic SQL to perform some database operations. These dynamic SQL is some cases might be created by...
Sunday, November 11, 2012
LinQ Extended Joins
The very first time that I was interested by LinQ, there in 2007, apart from the great admiration for the product and the whole range o...
What are SQL Joins and How to use thses..
The first thing we learn to do with SQL is writing a SELECT statement to get data from one table. This kind of statement seems to be str...
Saturday, November 10, 2012
Adding Email, Details field in UserProfile DB Table in MVC
Adding Email, Details field in UserProfile DB Table in MVC In this post you will learn how to add Email and Details columns in existing D...
Monday, October 22, 2012
Inner Join using LINQ for Multiple Tables (3 Tables Now) with Lambda
Inner Join using LINQ for Multiple Tables (3 Tables Now) with Lambda Inner Join using LINQ for Multiple Tables (3 Tables Now) with ...
Inner Join using LINQ
Inner Join using LINQ Inner Join using LINQ Introduction Today, in this article let's play around with one of the interesting...
Inner Join using LINQ with Lambda
Inner Join using LINQ with Lambda Inner Join using LINQ with Lambda Introduction Today, in this article let's play around wit...
Inner Join using LINQ for Multiple Tables (3 Tables Now)
Inner Join using LINQ for Multiple Tables (3 Tables Now) Inner Join using LINQ for Multiple Tables (3 Tables Now) Introduction To...
Monday, September 17, 2012
Performing Bulk Copy Operations on Database
There can be situation when we need to copy large amount of data from one location to another. For example, you have created a backup co...
Saturday, September 8, 2012
Local LINQ to SQL Database For Your WP7 Application
There aren't many applications that are of value without having some for of data store. In Windows Phone development we have a few op...
Thursday, August 30, 2012
HOWTO: SQLite with Windows 8 apps
I've previously posted a few things about SQLite including a HOWTO on how to build from their source code. If you still want to build...
Thursday, July 26, 2012
CT in SQL server 2008 R2
This article explores one of the features (of SQL server 2008 and higher) of providing the change tracking abilities i.e. what data has c...
