using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
namespace HelloWorldMvcApp
public class HomeController : Controller
public ActionResult Index()
List<Users> customers = new List<Users>();
using (IDbConnection db = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
customers = db.Query<Users>("Select * From Users").ToList();
public static void CreateDatabase()
using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
using (var command = connection.CreateCommand())
CREATE TABLE [dbo].[Users] (
[id] INT IDENTITY (1, 1) NOT NULL,
[name] NVARCHAR (MAX) NULL,
[email] NVARCHAR (MAX) NULL,
CONSTRAINT [PK_dbo.Customers] PRIMARY KEY CLUSTERED ([id] ASC)
INSERT INTO Users (name, email) Values ('Armando', 'armando@gmail.com');
INSERT INTO Users (name, email) Values ('Meredith','Meredith.Alonso@example.com');
INSERT INTO Users (name, email) Values ('Arturo', 'Arturo.Anand@example.com');
command.ExecuteNonQuery();