Alternative to Dynamic Data in Asp.Net Mvc

Question

Years ago Microsoft present Dynamic Data as a new generation scaffolding engine to make the fastest way to manage your data without mostly any code writing.

After some years without any news and without support for Entity Framework 6.x Dynamic Data is closed. Yes they make MvcScaffolding which is quite easy to use as a nice sample but it's not dynamic it let update code every you change your database (maybe I don't have some skills and this is easy or can be automatic). So have anybody found something new to manage EF models? Maybe this is something written with JavaScript (with breeze and OData that will looks interesting)? So I would be glad to hear about anything interesting to give up old Dynamic Data.

Christopher · Accepted Answer · 2014-05-26T18:02:09.643

4

2014-01-30: Dynamic Data is back!

2014-02-28: Dynamic Data is out of alpha, and a release version is available.

edited May 26 '14 at 18:02

answered Feb 19 '14 at 23:54

Christopher

10,409
13
73
97

Yeah, thanks to update correct answer. I forgot to do it myself – Denis Agarev Feb 21 '14 at 07:56
2

Any resources for implementing this in .NET MVC5? – David Myers Oct 16 '14 at 12:56

score 1 · Answer 2 · answered Dec 10 '13 at 15:28

1

Visual Studio LightSwitch may be an option, however I don't know if it will still be about in a few years time.

Oneday someone will come up with a web solution that works as well as MS-Access for simple data.

answered Dec 10 '13 at 15:28

Ian Ringrose

51,220
55
213
317

score 1 · Answer 3 · edited Apr 16 '15 at 03:26

1

I am using CamoteQ scaffolding tool.

https://camoteq.codeplex.com/

edited Apr 16 '15 at 03:26

Rick Arthur

2,410
21
15

answered Dec 26 '13 at 05:10

Ronald

1,532
4
18
34

score 0 · Answer 4 · answered Nov 11 '13 at 16:06

0

How dynamic do you want to go? Using T4 templates in your solution and re-running these will re-scaffold your templates which essentially makes them dynamic.

answered Nov 11 '13 at 16:06

Ropstah

17,538
24
120
194

Well, in fact in one step behind cause I need to update scaffolding project every my model change but maybe it will totally be a profit cause of better extensibility comparing to Dynamic Data. I'll play with updating, thanks. – Denis Agarev Nov 12 '13 at 06:49
1

Ok, Asp.Net Mvc Scaffolding it's good but even this article http://www.asp.net/visual-studio/overview/2013/aspnet-scaffolding-overview doesn't show how to rerun T4 transformation. Can you help with it? – Denis Agarev Nov 14 '13 at 06:29

user8128167 · Answer 5 · 2019-05-18T00:47:10.210

Intead of Microsoft.AspNet.DynamicData.EFProvider you can use AJAX and ASP.NET MVC without needing to download a separate NuGet package other than I think EntityFramework:

First create an employee table in a database with EmployeeId, EmployeeName, Email, Phone and Experience.

Then create an ASP.NET Web Application, choosing MVC, in Visual Studio. Now add this to your HomeController:

public class HomeController : Controller
{
    MyEntities db = new MyEntities ();
    public ActionResult Index()
    {
        return View(db.EmployeeInfos.ToList());
    }

    public ActionResult EmployeeInfo(int id)
    {
        List<EmployeeInfo> EmpInfo = db.EmployeeInfos.Where(x => x.EmployeeId == id).ToList();
        return View(EmpInfo);
    }
}

Next in your HomeController View open Index.cshml, and put in this code:

@model IEnumerable<DynamicallyLoadingContant.Models.EmployeeInfo>
           <br /><br />
<div class="container">
    <h3 style="text-align:center">-----Employee List-----</h3><br />
    <table class="table table-bordered">
        <tr>
            <th style="width:20%">ID</th>
            <th style="width:80%">Name</th>
        </tr>
       @foreach (var item in Model)
       {
           <tr>
               <td>@item.EmployeeId</td>
               <td><a href="#" data-toggle="popover" data-trigger="hover" id="@item.EmployeeId">@item.EmployeeName</a></td>
           </tr>
       }
    </table>
</div>
<script src="~/Scripts/jquery-1.10.2.min.js"></script>
<script>
    $(document).ready(function () {
        $('[data-toggle="popover"]').popover({
            title: setData,
            html: true,
            placement:'right'

        });
        function setData(id) {
            var set_data = '';
            var element = $(this);
            var id = element.attr("id");
            $.ajax({
                url: "/Home/EmployeeInfo?id" + id,
                method: "post",
                async: false,
                data: { id: id },
                success: function (data) {
                    set_data = data;
                }

            });
            return set_data;
        }
    });
</script>

Next add another EmployeeInfo.cshtml view:

@model IEnumerable<DynamicallyLoadingContant.Models.EmployeeInfo>
@{
    ViewBag.Title = "EmployeeInfo";
}
<div class="container">
    <h4 style=" text-align:center;border-bottom:1px solid #808080">EmployeeInfo</h4>
    @foreach (var item in Model)
    {
        <p><label>Name : </label> @item.EmployeeName</p>
        <p><label>Email : </label> @item.Email</p>
        <p><label>Phone : </label> @item.Phone</p>
        <p><label>Experience : </label> @item.Experience</p>
    }
</div>

For more details, please see http://abctutorial.com/Post/29/dynamically-loading-content-with-jquery-ajax-%7C-aspnet-mvc

Alternative to Dynamic Data in Asp.Net Mvc

5 Answers5