CSP414 - Data Access with ADO.NET and LINQ

Outline info
Last revision date 2018-07-20 11:56:37.565
Last review date 2018-07-20 11:56:43.832

Subject Title
Data Access with ADO.NET and LINQ

Subject Description
This subject will provide developers with a solid introduction to the primary strategies to access data stored in relational databases from .NET applications-ADO.NET, LINQ, and the Entity Framework. It starts with an in-depth coverage of ADO.NET including the connected/disconnected classes, how to bind data to ASP.NET data-bindable controls, then moves onto LINQ - an exciting addition to .NET 3.5. LINQ extends the .NET languages to make data access a part of the language itself (as opposed to and API such as ADO.NET). It is an abstraction layer that allows one to access data from disparate data sources (relational databases, XML, objects in memory) through the same syntax and semantics.

Credit Status
 This subject is part of the .NET Application Development Recognition of Achievement program.

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Understand the core ADO.NET object model.
2. Apply performance optimization strategies.
3. Write provider portable code.
4. Use ADO.NET within ASP.NET applications.
5. Understand LINQ and Entity Framework fundamentals.

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on http://library.senecacollege.ca for further information regarding cheating and plagiarism policies and procedures.

All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at student.conduct@senecacollege.ca.

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

CSP412 or equivalent experience.

Topic Outline

Understand the core ADO.NET object model

  • Connected and Disconnected classes
  • DataAdapters

Apply performance optimization strategies

Write provider portable code

Use ADO.NET within ASP.NET applications
  • Data controls
  • DataSources

Understand LINQ and Entity Framework fundamentals
  • LINQ query syntax and operations
  • LINQ to ADO.NET DataSets
  • LINQ to SQL
  • LINQ to .NET collections

Mode of Instruction
This course will be taught via class lectures and discussions, augmented with visual aids and supplemented by hands-on labs and exercises. 

Prescribed Texts
The following course materials will be provided:

Professional ADO.NET 3.5 with LINQ and the Entity Framework
(V & L)

Required Supplies

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online (http://www.senecacollege.ca/academic-policy) or at Seneca's Registrar's Offices.

Modes of Evaluation
This subject is part of the .NET Application Development program.  Those students choosing to pursue their .NET Application Recognition of Achievement are required to complete a final assignment or test.  The passing mark for each assignment/test is 70%.  All courses are graded as SAT (Satisfactory) for students who achieve 70% or higher or UNSAT (Unsatisfactory) for less than 70%. 

Approved by: Denis Gravelle