which database should be used in which requirement and how ?

Question

which database should be used in which requirement in C# ASP lang and how to connect with various databases  using C# ASP lang ? Please explain step wise and or any link to look over this issue.