# LINQ to SQL - Binding and Automatic CRUD Operations
LINQ to SQL is an object-relational mapping (ORM) implementation included in ASP.NET Framework 3.5. It lets you model a relational database with .NET classes, query the database with LINQ, and update, insert, or delete data. LINQ to SQL tracks changes to the objects and translates the queries and updates into SQL for the database.
LINQ to SQL supports transactions, views, and stored procedures. It also provides a way to integrate data validation and business logic rules into your data model.
For more information about LINQ to SQL, review the following resources:
* [Using LINQ to SQL](https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/)
* [LINQ to SQL: .NET Language-Integrated Query for Relational Data](https://msdn.microsoft.com/en-us/library/bb425822.aspx).
## Binding RadGrid to LinqDataSource
RadGrid for ASP.NET AJAX provides a declarative way to bind to `LinqDataSource`, similar to other ASP.NET data source controls. The example supports automatic data editing, hierarchical display, paging, and sorting. Configure the `LinqDataSource` properties at each level of the hierarchy, including the `Where` clause and `WhereParameters` for nested `LinqDataSource` controls.
To enable automatic editing at the data source level, set `AllowAutomaticUpdates`, `AllowAutomaticInserts`, and `AllowAutomaticDeletes` to `true` on the grid. Set the corresponding `EnableUpdate`, `EnableInsert`, and `EnableDelete` properties of the `LinqDataSource` to `true`.
## Configuring Automatic CRUD Operations
The following code snippets show the example configuration. They also demonstrate how to implement the `IBindableControl` interface for a custom Web User Control edit form.
> caption Example: Binding RadGrid to LINQ to SQL for automatic CRUD operations
```ASP.NET
```
```C#
protected void RadGrid1_ItemUpdated(object source, GridUpdatedEventArgs e)
{
if (e.Exception != null)
{
e.ExceptionHandled = true;
ShowErrorMessage();
}
}
protected void RadGrid1_ItemInserted(object source, GridInsertedEventArgs e)
{
if (e.Exception != null)
{
e.ExceptionHandled = true;
ShowErrorMessage();
}
}
protected void RadGrid1_ItemDeleted(object source, GridDeletedEventArgs e)
{
if (e.Exception != null)
{
e.ExceptionHandled = true;
ShowErrorMessage();
}
}
private void ShowErrorMessage()
{
RadAjaxManager1.ResponseScripts.Add(string.Format("window.radalert(\"Please enter valid data!\")"));
}
protected void RadGrid1_PreRender(object sender, EventArgs e)
{
if (!IsPostBack && RadGrid1.MasterTableView.Items.Count > 0)
{
RadGrid1.MasterTableView.Items[1].Expanded = true;
}
}
```
```VB
Protected Sub RadGrid1_ItemDeleted(ByVal source As Object, ByVal e As Web.UI.GridDeletedEventArgs) Handles RadGrid1.ItemDeleted
If e.Exception IsNot Nothing Then
e.ExceptionHandled = True
ShowErrorMessage()
End If
End Sub
Protected Sub RadGrid1_ItemInserted(ByVal source As Object, ByVal e As Web.UI.GridInsertedEventArgs) Handles RadGrid1.ItemInserted
If e.Exception IsNot Nothing Then
e.ExceptionHandled = True
ShowErrorMessage()
End If
End Sub
Protected Sub RadGrid1_ItemUpdated(ByVal source As Object, ByVal e As Web.UI.GridUpdatedEventArgs) Handles RadGrid1.ItemUpdated
If e.Exception IsNot Nothing Then
e.ExceptionHandled = True
ShowErrorMessage()
End If
End Sub
Protected Sub ShowErrorMessage()
RadAjaxManager1.ResponseScripts.Add(String.Format("window.radalert(""Please enter valid data!"")"))
End Sub
Protected Sub RadGrid1_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadGrid1.PreRender
If (Not IsPostBack AndAlso RadGrid1.MasterTableView.Items.Count > 0) Then
RadGrid1.MasterTableView.Items(1).Expanded = True
End If
End Sub
```
```ASP.NET
>
<%# DataBinder.Eval(DataItem,"ProductID") %>
```
```C#
public partial class Grid_Examples_dataediting_linqdatasource_productdetailscs:
UserControl, IBindableControl
{
public void ExtractValues(IOrderedDictionary dictionary)
{
// Retrieves all RadInputs and adds their values to the dictionary.
foreach (var input in Controls.OfType().Select(control => new { FieldName = control.ID, FieldValue = control.Text }))
{
dictionary.Add(input.FieldName, input.FieldValue);
}
}
public object DataItem { get; set; }
}
```
```VB
Partial Class Grid_Examples_dataediting_linqdatasource_productdetailsvb
Inherits System.Web.UI.UserControl
Implements IBindableControl
Public Sub ExtractValues(ByVal dictionary As System.Collections.Specialized.IOrderedDictionary) Implements System.Web.UI.IBindableControl.ExtractValues
For Each i In Controls.OfType(Of RadInputControl)().Select(Function(control) New With {.FieldName = control.ID, .FieldValue = control.Text})
dictionary.Add(i.FieldName, i.FieldValue)
Next
End Sub
Private dtItem As Object
Public Property DataItem() As Object
Get
Return dtItem
End Get
Set(ByVal value As Object)
dtItem = value
End Set
End Property
End Class
```
## See Also
* [Manual LINQ to SQL CRUD operations](https://www.telerik.com/products/aspnet-ajax/documentation/controls/grid/asp.net-3.5-features/linq-to-sql---binding-and-manual-crud-operations)
* [Entity Framework binding and CRUD operations](https://www.telerik.com/products/aspnet-ajax/documentation/controls/grid/asp.net-3.5-features/entity-framework---binding-and-crud-operations)
* [Client binding to WCF and ADO.NET data services](https://www.telerik.com/products/aspnet-ajax/documentation/controls/grid/asp.net-3.5-features/client-binding-to-wcf-web-service-and-ado.net-data-service)