What is the biggest benefit of the ListView Control
combines the strengths of those other data controls. Easy to display data in grid format to edit, allows to insert new records, and you get full control over markup.
Allows you to query directly from you vb programming code. Different types: to objects, to xml, to sql
To write Linq queries,
you use query operators that include keywords like, select, from, and where and aggregation operators like Sum and Count.
To get Data out of a linq query
you can use type inference to let the compiler determine the resulting type. This also allows you to create anonymous types, where the actual type returned by the query doesn't have a name, but its a public interface is inferred by the compiler.
To work with LINQ in ASP.NET
Can write code in code behind, means a lot of code manually. Another way is LinqDataSource control, the bridge between your data-bound controls and linq model.
retrieves the data and gives you the ability to create fully functional CRUD pages.
Linq to SQL
exclusively with SQl server, can turn database into .Net objects, use drag and drop to creat in VWD. Creates a layer between the .NET and the SQL server Database
can display data in a gride, in bullet or in flow format
used with ListView to do paging, a seperate control that you can use to extend another data-bound control, can define within the LayoutTemplateof the ListView or outside the ListView
Properties of a linq
enableDelete, enableInsert, enableUpdate
ContextTypeName of a linq
name of the DataContext class the control should use
tableName of Linq
the table from the Linq to SQL diagram you want to use, then use the data-bound control you desire to display the data