public ActionResult About(int? buttonClicked) { if (buttonClicked != null) { LinqToSql.TestDBLinqToSqlDataContext db = new LinqToSql.TestDBLinqToSqlDataContext(); Mapper.Reset(); Mapper.CreateMap<LinqToSql.Blog, Models.BlogSummary>(); var query = (from b in db.Blogs select b).ToArray(); var summaries = Mapper.Map<LinqToSql.Blog[], Models.BlogSummary[]>(query); return new JsonResult { Data = summaries, JsonRequestBehavior = System.Web.Mvc.JsonRequestBehavior.AllowGet }; } return View(); }
//// ADO.NET Entity Framework classes //public ActionResult Index() //{ // ViewBag.Message = "Blogs or something:"; // var db = new ADO.TestDBEntities(); // var blogs = db.Blogs.ToArray(); // Mapper.CreateMap<ADO.Blog, Models.BlogSummary>() // .AfterMap((src, dest) => dest.AuthorBio += "$") // .ForMember(x => x.AuthorBio, opt => // { // opt.NullSubstitute("N/A"); // opt.AddFormatter<BlogFormatter>(); // }); // var summaries = Mapper.Map<ADO.Blog[], Models.BlogSummary[]>(blogs); // return View(summaries.ToArray()); //} //// Used SqlConnections //public ActionResult Index() //{ // ViewBag.Message = "Blogs or something:"; // Mapper.Reset(); // Mapper.CreateMap<IDataReader, Models.BlogSummary>() // .ForMember(m => m.AuthorName, opt => opt.MapFrom(r => r.GetString(r.GetOrdinal("Name")))) // .ForMember(m => m.AuthorAge, opt => opt.MapFrom(r => r.GetInt32(r.GetOrdinal("Age")))) // .ForMember(m => m.AuthorBio, opt => opt.MapFrom(r => r.GetString(r.GetOrdinal("Bio")))); // IEnumerable<Models.BlogSummary> summaries = null; // using (SqlConnection connection = new SqlConnection(@"server=.\SQLEXPRESS; DataBase=TestDB; Integrated Security=SSPI")) // { // var command = connection.CreateCommand(); // command.CommandText = "dbo.GetAllBlogs"; // command.CommandType = System.Data.CommandType.StoredProcedure; // connection.Open(); // summaries = Mapper.Map<IDataReader, IEnumerable<Models.BlogSummary>>(command.ExecuteReader()); // } // return View(summaries.ToArray()); //} // Used LINQ to SQL implementation public ActionResult Index() { LinqToSql.TestDBLinqToSqlDataContext db = new LinqToSql.TestDBLinqToSqlDataContext(); Mapper.Reset(); Mapper.CreateMap<LinqToSql.Blog, Models.BlogSummary>(); //.ForMember(m => m.AuthorName, opt => opt.MapFrom(r => r.Name)) //.ForMember(m => m.AuthorBio, opt => opt.MapFrom(r => r.Bio)) //.ForMember(m => m.AuthorAge, opt => opt.MapFrom(r => r.Age)) //.ForMember(m => m.AuthorHometown, opt => opt.MapFrom(r => r.Hometown)); //var query = db.GetAllBlogs().ToArray(); var query = (from b in db.Blogs select b).ToArray(); var summaries = Mapper.Map<LinqToSql.Blog[], Models.BlogSummary[]>(query); return View(summaries); }