Esempio n. 1
0
        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();
        }
Esempio n. 2
0
        //// 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);
        }