CRUD Operations
The following example demonstrates how to save, read, update and delete a text data content in a local database using the Editor component.
For a runnable project, refer to this GitHub repository. The previously linked example assumes you have Telerik UI for ASP.NET Core and Entity framework installed and a local database set up.
This code has no applied XSS attack prevention and it is the responsibility of the developer to manage these security risks. For more information, refer to the article on preventing cross-site scripting.
The following example demonstrates how to define the database model.
public class EditorDataContext : DbContext
{
public EditorDataContext(DbContextOptions<EditorDataContext> options)
: base(options)
{ }
public DbSet<EditorData> EditorData { get; set; }
}
public class EditorData
{
[Key]
public int ContentId { get; set; }
public string EditorContent { get; set; }
}
The following example demonstrates how to define the Index page of your application.
<h1>Index</h1>
<p>
<a asp-action="Create" class="k-button">Create New</a>
</p>
<table class="table">
<thead>
<tr>
<th>
@Html.DisplayNameFor(model => model.EditorContent)
</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model) {
<tr>
<td>
@Html.DisplayFor(modelItem => item.EditorContent)
</td>
<td>
<a asp-action="Edit" asp-route-id="@item.ContentId" class="k-button k-primary">Edit</a> |
<a asp-action="Details" asp-route-id="@item.ContentId" class="k-button">Details</a> |
<a asp-action="Delete" asp-route-id="@item.ContentId" class="k-button">Delete</a>
</td>
</tr>
}
</tbody>
</table>
public async Task<IActionResult> Index()
{
return View(await _context.EditorData.ToListAsync());
}
The following example demonstrates how to add the content of the Editor to the database.
<h1>Create</h1>
<h4>EditorData</h4>
<hr />
<div class="row">
<div class="col-md-4">
<form asp-action="Create" id="EditorDataForm">
<div asp-validation-summary="ModelOnly" class="text-danger"></div>
<div class="form-group">
<label asp-for="EditorContent"></label>
@Html.Kendo().EditorFor(m => m.EditorContent)
<span asp-validation-for="EditorContent" class="text-danger k-invalid-msg" data-for="EditorContent"></span>
</div>
<div class="form-group">
<input type="submit" value="Create" class="k-button k-primary" />
</div>
</form>
</div>
</div>
<div>
<a asp-action="Index" class="k-button">Back to List</a>
</div>
<h1>Create</h1>
<h4>EditorData</h4>
<hr />
<div class="row">
<div class="col-md-4">
<form asp-action="Create" id="EditorDataForm">
<div asp-validation-summary="ModelOnly" class="text-danger"></div>
<div class="form-group">
<label asp-for="EditorContent"></label>
<kendo-editor for="EditorContent">
</kendo-editor>
<span asp-validation-for="EditorContent" class="text-danger k-invalid-msg" data-for="EditorContent"></span>
</div>
<div class="form-group">
<input type="submit" value="Create" class="k-button k-primary" />
</div>
</form>
</div>
</div>
<div>
<a asp-action="Index" class="k-button">Back to List</a>
</div>
public IActionResult Create()
{
return View();
}
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Create([Bind("ContentId,EditorContent")] EditorData editorData)
{
if (ModelState.IsValid)
{
_context.Add(editorData);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
return View(editorData);
}
The following example demonstrates how to read the stored data in the database.
<h1>Details</h1>
<div>
<h4>EditorData</h4>
<hr />
<dl class="row">
<dt class = "col-sm-2">
@Html.DisplayNameFor(model => model.EditorContent)
</dt>
<dd class = "col-sm-10">
@Html.DisplayFor(model => model.EditorContent)
</dd>
</dl>
</div>
<div>
<a asp-action="Edit" asp-route-id="@Model.ContentId" class="k-button k-primary">Edit</a> |
<a asp-action="Index" class="k-button">Back to List</a>
</div>
public async Task<IActionResult> Details(int? id)
{
if (id == null)
{
return NotFound();
}
var editorData = await _context.EditorData
.FirstOrDefaultAsync(m => m.ContentId == id);
if (editorData == null)
{
return NotFound();
}
return View(editorData);
}
The following example demonstrates how to edit the stored data.
<h1>Edit</h1>
<h4>EditorData</h4>
<hr />
<div class="row">
<div class="col-md-4">
<form asp-action="Edit" id="EditorDataForm">
<div asp-validation-summary="ModelOnly" class="text-danger"></div>
<input type="hidden" asp-for="ContentId" />
<div class="form-group">
<label asp-for="EditorContent"></label>
@Html.Kendo().EditorFor(m => m.EditorContent)
<span asp-validation-for="EditorContent" class="text-danger k-invalid-msg" data-for="EditorContent"></span>
</div>
<div class="form-group">
<input type="submit" value="Save" class="k-button k-primary" />
</div>
</form>
</div>
</div>
<div>
<a asp-action="Index" class="k-button">Back to List</a>
</div>
<h1>Edit</h1>
<h4>EditorData</h4>
<hr />
<div class="row">
<div class="col-md-4">
<form asp-action="Edit" id="EditorDataForm">
<div asp-validation-summary="ModelOnly" class="text-danger"></div>
<input type="hidden" asp-for="ContentId" />
<div class="form-group">
<label asp-for="EditorContent"></label>
<kendo-editor for="EditorContent">
</kendo-editor>
<span asp-validation-for="EditorContent" class="text-danger k-invalid-msg" data-for="EditorContent"></span>
</div>
<div class="form-group">
<input type="submit" value="Save" class="k-button k-primary" />
</div>
</form>
</div>
</div>
<div>
<a asp-action="Index" class="k-button">Back to List</a>
</div>
public async Task<IActionResult> Edit(int? id)
{
if (id == null)
{
return NotFound();
}
var editorData = await _context.EditorData.FindAsync(id);
if (editorData == null)
{
return NotFound();
}
return View(editorData);
}
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Edit(int id, [Bind("ContentId,EditorContent")] EditorData editorData)
{
if (id != editorData.ContentId)
{
return NotFound();
}
if (ModelState.IsValid)
{
try
{
_context.Update(editorData);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EditorDataExists(editorData.ContentId))
{
return NotFound();
}
else
{
throw;
}
}
return RedirectToAction(nameof(Index));
}
return View(editorData);
}
The following example demonstrates how to delete records from the database.
public async Task<IActionResult> Delete(int? id)
{
if (id == null)
{
return NotFound();
}
var editorData = await _context.EditorData
.FirstOrDefaultAsync(m => m.ContentId == id);
if (editorData == null)
{
return NotFound();
}
return View(editorData);
}
[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public async Task<IActionResult> DeleteConfirmed(int id)
{
var editorData = await _context.EditorData.FindAsync(id);
_context.EditorData.Remove(editorData);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}