Writting common Dataaccess layer for MYSQL, Oracle and SQL server by using enterprise library

http://www.c-sharpcorner.com/UploadFile/munnamax/EntLibDAAB07052007055557AM/EntLibDAAB.aspx
http://forums.asp.net/t/1295707.aspx?Writting+common+Dataaccess+layer+for+MYSQL+Oracle+and+SQL+server+by+using+enterprise+library+Parameterized+query+

Encrypt Decrypt ConnectionString in Web.Config

http://www.codeproject.com/Tips/795135/Encrypt-ConnectionString-in-Web-Config?loginkey=false

cd C:\Windows\Microsoft.NET\Framework\v4.0.30319

ASPNET_REGIIS -pef "connectionStrings" "D:\Articles\EncryptWebConfig" use this command

here EncryptWebConfig is project name

for decrypt 

ASPNET_REGIIS -pdf "connectionStrings" "D:\Articles\EncryptWebConfig" use this command

Linq to Method

http://www.codeproject.com/Tips/858694/Linq-Queries-Examples-Using-Method-And-Query-Synta

Json String Format

{"request_body":[{"username":eee,"password":"eee."}]}

ssis

http://mirror.dorkfolio.net/Books/SQL/SSIS%20Integration.pdf

Difference between CTE and Temp Table and Table Variable

http://www.dotnet-tricks.com/Tutorial/sqlserver/X517150913-Difference-between-CTE-and-Temp-Table-and-Table-Variable.html

update multiple rows single query sql server

declare @SymptomID int=46

update MD_RS_SymptomsReviewQuestions
 set Sequence = bb.Number
 from MD_RS_SymptomsReviewQuestions
 join
 (

select a.* --ROW_NUMBER() over (ORDER BY id) AS Number
from MD_RS_SymptomsReviewQuestions a
where a.SymptomID = @SymptomID
and a.IsDeleted = 0
and a.Sequence <= 0
 )aa
 on aa.ID = MD_RS_SymptomsReviewQuestions.ID
 join
 (
select b.ID, ROW_NUMBER() over (ORDER BY id) AS Number
from MD_RS_SymptomsReviewQuestions b
where b.SymptomID = @SymptomID
and b.IsDeleted = 0
and b.Sequence <= 0
 )bb
 on bb.ID = aa.ID