
https://www.youtube.com/user/VisualStudio/playlists
from http://www.telerik.com/data-access
is part of Telerik DevCraft—the ultimate product bundle for professional developers targeting Microsoft platforms.
Gain access to the complete stack of products to help you build your next web, mobile or desktop app:
Data Access offers extensive LINQ support against all supported databases, which has been validated with the Microsoft 101 LINQ to SQL Samples (available in the Data Access Samples Kit). The major advantage of LINQ is the compile-time check of your queries-meaning no surprises at run time.
Telerik Data Access can be used with a wide variety of relational backends. It offers specific features such as support for SQLGeometry and SQLGeography types in MS SQL Server, RefCursors and Auto-increment Sequences in Oracle. It also offers various types of Stored Procedures and Functions for each database, Data streaming to blob storage columns and more.
Telerik Data Access can be used with a wide variety of relational backends. It offers specific features such as support for SQLGeometry and SQLGeography types in MS SQL Server, RefCursors and Auto-increment Sequences in Oracle. It also offers various types of Stored Procedures and Functions for each database, Data streaming to blob storage columns and more.
Database-first mapping is the process of creating a set of objects and .NET classes to be used in your application from an already existing database. This approach is also known as Schema-First and Reverse Mapping. Data Access recognizes the data model, the data types and any additional information like keys and stored procedures, and then generates the object model and related C# or VB.NET code. The process is transparent and you have complete control over the created mapping by using the Create Model Wizard.
Model-First Mapping (also known as Forward mapping) takes your existing object model and creates an optimized database schema. In Telerik Data Access, this process is handled by the Update Database from Model wizard. It can generate your database and maintain its schema for you so that you will not have to do anything during the design phase.
The unique capability called Round-trip Mapping means you don’t have to choose in advance whether to forward- or reverse-map your project. With the help of Telerik Data Access Visual Designer in Visual Studio, you employ both approaches.
If you view code as your model, preferring to write code instead of using visual assistance tools, Telerik Data Access provides Fluent Mapping API that assists you in setting-up your classes for use with Data Access. There is no need to touch a designer or work with the XML mappings.The completely automated, initial Fluent Mapping code generation is done by Data Access. The Data Access Fluent API covers 100 percent of the the functionality of the mapper, and is efficiently used by Telerik Sitefinity CMS. If required, your model can be visually adjusted in the Visual Mapping Designer.
Data Access allows you to create new or reuse existing Stored Procedures and follow the widely adopted pattern of DB logic encapsulation inside the database. Under higher security requirements, the stored procedures can be used for all insert, read, update and delete operations to inject additional checks in the database server. A Stored Procedures Editor simplifies the set-up and use of stored procedures.
Telerik Data Access forward and reverse mapping enables you to map database views and tables to classes. The data exposed by the tables and views can be modified and then stored back to the database.
The Data Access Model is created in Visual Studio with the aid of numerous tools and wizards, which simplify the process to point-and-click table to object mapping. The model describes the application-specific object or “conceptual” model against which you can program. It raises the abstraction level above logical database schemas, which also allows you to reuse it in different applications and for different databases.
Data Access uses standard .NET conventions and idioms (inheritance, polymorphism, composition, .NET/generic collections, etc.). It does not use .NET reflection. The code is free of data access code “plumbing” and is enhanced transparently after compilation. The code generated by Data Access closely follows all established .NET and object-oriented programming standards.
All classes in Telerik Data Access are persistent ignorant and work independently from the source code and database. This means true portability for your .NET applications, where you can switch the database and reuse the same code and even data model.
You only need to modify the state of an object when updating data – Data Access takes care of the rest. Because the programming model does not change, you do not need to know any of the SQL performed on the backend. Telerik Data Access converts the commands issued by the domain model at runtime (usually via LINQ or low-level API), into backend database retrieval and SQL statements. This frees you from writing the time-consuming CRUD operations. Data Access helps you with the following CRUD operations:
Data Access provides the Model Operations that enable you to update your model in a few clicks. This is done through a simple dialog, so you can:
All classes enhanced by Telerik Data Access are still normal CLR objects, and as such, can be easily tested by state of the art unit tests. SQL code can be traced by writing it to the console, in a text file or to the .NET tracing framework. Performance counters show you the state of your running application, website or application server.
Now on Pluralsight:
The ASP.NET MVC 5 Fundamentals training course spends most of its time on new features for version 5 of the framework, including:
The Building Applications with ASP.NET MVC 4 training course is a start to finish introduction to programming with ASP.NET MVC 4. Some of the demos in the 7+ hours of content include:
– Using controllers, action results, action filters and routing
– Razor views, partial views, and layout views
– Models, view models, data annotations, and validation
– Custom validation attributes and self-validating models
– Entity Framework 5 code-first programming
– Entity Framework migrations and seeding
– Security topics including mass assignment and cross site request forgeries
– Using JavaScript and jQuery to add paging, autocompletion, async form posts, and async searches
– Taking control of Simple Membership
– Using OAuth and OpenID
– Caching, localization, and diagnostics
– Error logging with ELMAH
– Unit testing with Visual Studio 2012
– Deploying to IIS
– Deploying to a Microsoft Windows Azure web site
Enjoy!