- Scalability
- Distributed nature
-
EDM
-
Object services
- support different programming languages
-
object state manager
- cache states
- Track changes
- abstract data entity as objects
-
Mapping
-
Schema definition
-
Types
- Inheritence
- Automatic association operations (conceptual advantage)
- Type checking before runtime
-
Conceptual and Logical
- More robust remote database access
- Abstract problem in conceptual level
-
Data Service
- Access as a web service
-
Operations
- Query
- Update
-
The conventional database programming problem
- Typing
- Static typing
- Interface styles
- Optimization
- Reuse
- Concurrency
-
DataSet
-
Contains
- Tables
- Relationship
- Constraints
-
Flexibility of disconnected operations
-
SourceVersion values
- Current
- Original
- Default
-
Data source states
- Prevent changes
- Missing Schema Action
- Events
-
Strongly type
- Using XSD schema
- Change variable names
- Table View
-
XML
- XSLT transformation
- Access dataset as xml document
-
LinQ
- To SQL
-
To Entity
- Prevent changes from developers
- ORM 1:1 solution
- Partial class method
- Security
-
Performance
-
EDM
-
Improvement on EDM queries
- Precompile queries
- Turn on or off state tracking
- Tuning performance by using paging
- Analysis
- Asynchronous database execution