Storing Asp.net MVC5 Razor code in database and process to get values at runtime

Question

<table>
    @foreach(var items in Model)
    {
        <tr>
            <td>@items.name</td>
            <td>@items.designation</td>
            <td>@items.salary</td>
        </tr>
    }
</table>

The code works fine when written directly on cshtml page.

If I use @Html.Raw(items.data) it shows the code instead of data/Values.

My requirement is to store the above code in database and display records stored in database and process it at runtime. I want to fetch data by the code.

welll you are getting the values of `@items.name` from `Model` — jamiedanq, Apr 26 '16 at 08:19
similar question to this: http://stackoverflow.com/questions/7523918/asp-net-mvc-execute-razor-from-db-string — scgough, Apr 26 '16 at 08:42

score 3 · Answer 1 · answered Apr 26 '16 at 09:37

3

You can use RazorEngine for templating: Your string in your database will be your template, then you can send your model as model for the template.

 string template = "Hello @Model.Name! Welcome to Razor!";
 string result = Razor.Parse(template, new { Name = "World" });

In the example above, the first param is your template, the second the model.

answered Apr 26 '16 at 09:37

Jean-Charbel VANNIER

396
1
13

Nice solution, think this is what Nikhil needs ..(+1) – SamGhatak Apr 26 '16 at 14:43

score 0 · Answer 2 · answered Apr 26 '16 at 09:34

I don't think you can store razor code into database and reuse it. Because when you use @Html.Raw(), the view engine expects the string to be HTML code, and leaves it to be interpreted by the browser. If you keep razor codes there it goes straight to the browser. Expecting html syntaxes and getting razor ones, the browser gives you back the code...Hope it makes sense..

Storing Asp.net MVC5 Razor code in database and process to get values at runtime

2 Answers2