static void Main(string[] args) { var readContacts = new List <Contact>(); #region "ADO.NET" //using ( // var dbConnection = // new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString)) //{ // var dbCommand = new SqlCommand("select Id, FirstName, LastName, Email, Phone from dbo.Contact", dbConnection); // dbConnection.Open(); // SqlDataReader myDataReader = dbCommand.ExecuteReader(); // while (myDataReader.Read()) // { // //entity mapping // var readContact = new Contact // { // FirstName = myDataReader["FirstName"].ToString(), // LastName = myDataReader["LastName"].ToString(), // Email = myDataReader["Email"].ToString(), // Phone = myDataReader["Phone"].ToString() // }; // readContacts.Add(readContact); // } //} #endregion #region "Dapper" //using (var dbConnection = // new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString)) //{ // dbConnection.Open(); // IEnumerable<Contact> readDapperContacts = dbConnection.Query<Contact>("select Id, FirstName, LastName, Email, Phone from dbo.Contact", // null, null, false, null, CommandType.Text); // readContacts = readDapperContacts.ToList(); //} #endregion #region "Entity Framework" readContacts = new ContactEdm().Contacts.ToList(); #endregion foreach (Contact currentContact in readContacts) { currentContact.Output(); } System.Console.ReadLine(); }
static void Main(string[] args) { var readContacts = new List<Contact>(); #region "ADO.NET" //using ( // var dbConnection = // new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString)) //{ // var dbCommand = new SqlCommand("select Id, FirstName, LastName, Email, Phone from dbo.Contact", dbConnection); // dbConnection.Open(); // SqlDataReader myDataReader = dbCommand.ExecuteReader(); // while (myDataReader.Read()) // { // //entity mapping // var readContact = new Contact // { // FirstName = myDataReader["FirstName"].ToString(), // LastName = myDataReader["LastName"].ToString(), // Email = myDataReader["Email"].ToString(), // Phone = myDataReader["Phone"].ToString() // }; // readContacts.Add(readContact); // } //} #endregion #region "Dapper" //using (var dbConnection = // new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString)) //{ // dbConnection.Open(); // IEnumerable<Contact> readDapperContacts = dbConnection.Query<Contact>("select Id, FirstName, LastName, Email, Phone from dbo.Contact", // null, null, false, null, CommandType.Text); // readContacts = readDapperContacts.ToList(); //} #endregion #region "Entity Framework" readContacts = new ContactEdm().Contacts.ToList(); #endregion foreach (Contact currentContact in readContacts) { currentContact.Output(); } System.Console.ReadLine(); }