Join over 35,000 students, from 300 countries, who already obtained their computer training with us.
Duration: 5 Days
Registration Open Now!
This course is recommended for professional .NET software developers who use Microsoft Visual Studio in a team-based, medium-sized to large development environment. This course is also tailored to individuals who have some experience using Visual Studio 2010 for either Windows client or Web application development.
This Course focuses on database or data source connectivity within .NET applications. This includes Good Practices for structure of the application. The course goes through usage of the ADO.NET Entity Framework, LINQ, Windows Communication Foundation (WCF) Data Services, The Sync Framework and ADO.NET.
This course is most commonly run through mentored learning in the “MyChoice” environment where there are instructors available to assist you, one-on-one, while you are going through the course content.
What is ADO.Net? ADO.NET is a framework containing many Data Access Objects such as the “Connection” Object to connect to SQL Server Databases as well as other Data sources through OLE DB and XML. The main Objects used are the Connection, Command, DataReader, DataAdapter and it gets a DataSet Object.
Example of ADO.NET Code:
String strCon = @"Data Source=NH\SQLSERVER; Initial Catalog=Northwind; Integrated Security=SSPI"; String sqlQuery="SELECT *FROM Students"; SqlConnection con=new SqlConnection(strCon); con.Open(); SqlDataAdapter adapter=new SqlDataAdapter(); adapter.SelectCommand=new SqlCommand(strSql,con); DataSet result=new DataSet(); dadapter.Fill(result); con.Close();
Creating data Access solutions allows you to implement a database to be used in application so that information does not necessarily need to be stored locally. A database should be set up in such a way that information stored can be accessed without information becoming inaccurate or unavailable. Depending on the database, there can also be storage methods used to eliminate redundancy as far as possible.
Module 1: Architecture and Data Access Technologies
Module 2: Building Entity Data Models
Module 3: Querying Entity Data
Module 4: Creating, Updating, and Deleting Entity Data
Module 5: Handling Multi-User Scenarios by Using Object Services
Module 6: Building Optimized Solutions by Using Object Services
Module 7: Customizing Entities and Building Custom Entity Classes
Module 8: Using POCO Classes with the Entity Framework
Module 9: Building an N-Tier Solution by Using the Entity Framework
Module 10: Handling Updates in an N-Tier Solution by Using the Entity Framework
Module 11: Building Occasionally Connected Solutions
Module 12: Querying Data by Using WCF Data Services
Module 13: Updating Data by Using WCF Data Services
Module 14: Using ADO.NET
Module 15: Using LINQ to SQL