Ado net entity framework
Download
1 / 16

ADO.NET Entity Framework 소개 - PowerPoint PPT Presentation


  • 204 Views
  • Uploaded on

ADO.NET Entity Framework 소개. 2008.11.15. 한용희 Microsoft Visual C# MVP http://blog.naver.com/woom333. 차례. Programmer VS. Data Base Administrator Object VS. Data LINQ LINQ Project LINQ to SQL LINQ to Entities LINQ to DataSet 유연한 매핑 M:N 매핑 Entity Splitting Table per Hierarchy

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' ADO.NET Entity Framework 소개' - ifama


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Ado net entity framework

ADO.NET Entity Framework 소개

2008.11.15

한용희

Microsoft Visual C# MVP

http://blog.naver.com/woom333


차례

  • Programmer VS. Data Base Administrator

  • Object VS. Data

  • LINQ

    • LINQ Project

    • LINQ to SQL

    • LINQ to Entities

    • LINQ to DataSet

  • 유연한 매핑

    • M:N 매핑

    • Entity Splitting

    • Table per Hierarchy

    • Table per Type

  • DEMO



Object vs data
Object VS. Data

Object

Object

Object

Conceptual

Model

Mapping

Storage

Model


Linq language integrated queries

LINQ(Language Integrated Queries)


Linq project

<book>

<title/>

<author/>

<year/>

<price/>

</book>

Relational

Objects

XML

LINQ Project

.NET Language Integrated Query

LINQ toObjects

LINQ toDataSets

LINQ toSQL

LINQ toEntities

LINQ toXML

C# 3.0

Visual Basic 9.0

Others


Linq to sql
LINQ to SQL

  • 신속한 개발을 해야 할 때

  • Microsoft SQL Server만 지원

  • 직접 매핑(Direct Mapping)

    • 한 클래스는 SQL 스키마 한 객체에 직접 대응

      • 테이블 , 뷰

      • 저장 프로시저, 테이블 값 함수(Table Valued Function)

    • 테이블, 컬럼에 대한 이름 변경

    • 외래키를 통하여 관계를 설정

    • 상속

      • TPH (Table per Hierarchy) 지원


Linq to entities
LINQ to Entities

  • 엔터프라이즈급에서 사용

  • 다양한 DB(Oracle, DB2, Microsoft SQL Server) 사용 가능

  • 유연한 매핑(Flexible Mapping)

    • 하나의 클래스를 다수의 테이블/뷰와 매핑

    • 상속

      • TPH (Table per Hierarchy)

      • TPT (Tableper Type)

    • Complex Type (예: 주소[시,구,동,번지] 타입)

    • M:N 관계 표현


Linq to dataset
LINQ to DataSet

  • 비연결 기반 (Disconnected Cache)

  • 형식화된 데이터 집합(Typed DataSet)

    • 필드명으로참조

  • 형식화 되지 않은 데이터 집합(Untyped DataSet)

    • 강력한 타입으로 참조

var query = from row in myDataSet.Tables["Customers"].AsEnumerable()

where row .Field<string>("City") == "London"

select new { row.Field <string> ("CustomerID"),

row.Field <string> ("ContactName") } ;

var query = from customer in northwind.Customers

where customer.City == "London"

select customer;


Flexible mapping

유연한 매핑 (Flexible Mapping)


M:N 매핑


Entity splitting
Entity Splitting

Entity Data Model

Relational Data Source


Table per hierarchy tph
Table Per Hierarchy(TPH)

Entity Data Model

Relational Data Source


Table per type tpt
Table Per Type (TPT)

Entity Data Model

Relational Data Source


ad