More Related Content
What's hot (20)
Viewers also liked (20)
Similar to ADO .NET Entity framework (20)
ADO .NET Entity framework
- 1. GI I THI U ADO.NET畛 畛 ENTITY FRAMEWORK minhtri.itp@gmail.com1
- 2. N畛I DUNG 2
- 3. I. GI畛I THI畛U ENTITY FRAMEWORK L n畛n t畉ng truy c畉p d畛 li畛u c畛a Microsoft bao g畛m m畛t t畉p h畛p c叩c k畛 thu畉t 動畛c k畉 th畛a v ph叩t tri畛n t畛 ADO.NET. Gi炭p l畉p 畉y kho畉ng c叩ch gi畛a l畉p tr狸nh h動畛ng 畛i t動畛ng v c董 s畛 d畛 li畛u. Phi棚n b畉n 畉u ti棚n ph叩t hnh vo th叩ng 7 nm 2008 nh動 m畛t ph畉n c畛a Visual Studio 2008 SP1. Entity Framework 4.1 l phi棚n b畉n m畛i nh畉t 動畛c ph叩t hnh vo th叩ng 7 nm 2011. 3
- 4. II. KI畉N TRC Ki n tr炭c c a Entity Framework畉 畛 4
- 5. II. KI畉N TRC (TT) Ki n tr炭c c a Entity Framework畉 畛 I. Entity Data Model l s k t畛 畉 h p c a 3 m担 h狸nh:畛 畛 1. Conceptual Schema 2. Mapping Schema 3. Logical Schema Conceptual l m担 h狸nh quan ni m d li u m担 t c叩c th c th畛 畛 畛 畉 畛 畛 (entity/object) v m i quan h畛 畛 gi a ch炭ng.畛 Mapping th c hi n nhi m v畛 畛 畛 畛 叩nh x gi a m担 h狸nh quan ni m畉 畛 畛 d li u v m担 h狸nh logic畛 畛 Logical(Storage) M担 t c叩c畉 b ng d li u, view, procerdure v畉 畛 畛 m i quan h gi a ch炭ng畛 畛 畛 5
- 6. II. KI畉N TRC (TT) Truy v n d li u nh th no?畉 畛 畛 動 畉 坦 l c但u h i c t ra c a c叩c nh ph叩t畛 動畛 畉 畛 tri n Entity Framework t khi x但y d ng.畛 畛 畛 S d ng SQL Query? N u s d ng s kh担ng h畛 畛 畉 畛 畛 畉 畛 tr c nhi u h qu n tr c s d li u.畛 動畛 畛 畛 畉 畛 董 畛 畛 畛 Ng担n ng truy v n ch鱈nh c ch n l畛 畉 動畛 畛 LINQ to Entities, b棚n c nh 坦 v n h tr m t畉 畉 畛 畛 畛 ng担n ng truy v n kh叩c t ng t nh SQL 坦 l畛 畉 動董 畛 動 Entity SQL, ngoi ra v i EF cho ph辿p ch炭ng ta c坦畛 th g i tr c ti p m t c但u l nh SQL hay m t畛 畛 畛 畉 畛 畛 畛 Procerdure t database.畛 6
- 7. NH NG C I M N I B T C A ENTITY畛 畉 畛 畛 畉 畛 FRAMEWORK H tr cho nhi u h qu n tr c s d li u畛 畛 畛 畛 畉 畛 董 畛 畛 畛 o MSSQL Server, Oracle, MySql, PostgreSQL, SQL Anywhere, DB2,Informix ,U2, Ingres, Progress, Firebird, Synergy, Virtuoso T o ra m担 h狸nh chung gi a database v m担畉 畛 h狸nh th c th quan h c a ng d ng畛 畛 畛 畛 畛 畛 Truy v n d li u th担ng qua Linq to Entities畉 畛 畛 H tr ki u d li u ph c h p (Complex Type畛 畛 畛 畛 畛 畛 畛 Support) H tr nhi u c叩ch t o ra m担 h狸nh v c坦 th畛 畛 畛 畛 畉 畛 hi u ch nh m担 h狸nh m t c叩ch tr c quan (Model畛 畛 畛 畛 Browser Improvements) V m t s t鱈nh nng kh叩c.畛 畛 7
- 8. II. NH NG C I M N I B T C A畛 畉 畛 畛 畉 畛 ENTITY FRAMEWORK Linh ho t trong vi c m担 h狸nh h坦a d li u h ng畉 畛 畛 畛 動畛 i t ng畛 動畛 DB Model DB Model DB Model Model First (VS 2010 and .NET 4.0) Code First (Only) (Entity Framework Feature CTP5) Database First (VS 2008 and .NET 3.5 SP1) 8
- 9. III.NH畛NG KH KHN HI畛N NAY V i m担 h狸nh l p tr狸nh N- tier ng i l p tr狸nh ph i畛 畉 動畛 畉 畉 m t kh叩 nhi u th i gian thi t k Data Access畉 畛 畛 畛 畉 畉 Layer. V i m担 h狸nh (MVC,MVP) c n kh叩 nhi u th i gian cho畛 畉 畛 畛 c u tr炭c Model.畉 Kh担ng ki m so叩t c thay i gi a Database v code畛 動畛 畛 畛 ch ng tr狸nh(L i kh担ng ph叩t hi n c).動董 畛 畛 動畛 Kh nng chuy n i HQTCSDL r t kh坦 khn.畉 畛 畛 畉 Ng i l p tr狸nh ph i hi u r探 ki n tr炭c v SQL Query動畛 畉 畉 畛 畉 c a t ng h qu n tr c s d li u.畛 畛 畛 畉 畛 董 畛 畛 畛 Th i gian v chi ph鱈 s n xu t ph n m m tng畛 畉 畉 畉 畛 Kh坦 khn cho vi c b o tr狸 v n但ng c p ph n m m.畛 畉 畉 畉 畛 9
- 10. IV.ENTITY FRAMEWORK GI畉I QUY畉T NH畛NG KH KHN NH働 TH畉 NO? V i vi c truy v n d li u th担ng qua Entity Data畛 畛 畉 畛 畛 Model L p Data Access (N-Tier), Model (MVC,MVP) 達 c畛 動畛 Entity Framework h tr ng i l p tr狸nh ch t p畛 畛 動畛 畉 畛 畉 trung vo nghi p v kh叩c hng (buisiness rule) v畛 畛 giao di n ng i d湛ng.畛 動畛 D dng chuy n i sang h qu n tr c s d畛 畛 畛 畛 畉 畛 董 畛 畛 li u kh叩c.畛 Khi thay i c u tr炭c database ch c n 叩nh x l i畛 畉 畛 畉 畉 畉 EDM. Nh ng l i do thay i c u tr炭c database c畛 畛 畛 畉 動畛 ph叩t hi n ngay l炭c bi棚n d ch ch ng tr狸nh (Tr叩nh畛 畛 動董 c l i ti m n).動畛 畛 畛 畉 10
- 11. IV.ENTITY FRAMEWORK GI畉I QUY畉T NH畛NG KH KHN NH働 TH畉 NO? Ng i l p tr狸nh ch c n bi t LINQ l c坦 th truy動畛 畉 畛 畉 畉 畛 v n d li u kh担ng c n ph i bi t nhi u v c u畉 畛 畛 畉 畉 畉 畛 畛 畉 tr炭c SQL query, c i m c a m i h qu n tr c畉 畛 畛 畛 畛 畉 畛 董 s d li u.畛 畛 畛 V i LINQ ch炭ng ta c坦 th chia c叩c th t c SQL畛 畛 畛 畛 ph c t p ra thnh nhi u hm, bi n l u tr d畛 畉 畛 畉 動 畛 畛 li u (Entity Object) theo ch c nng. Nh 坦 qu叩畛 畛 畛 tr狸nh Debug, b o tr狸, n但ng c p c c th c畉 畉 動畛 動畛 畛 hi n d dng h n.畛 畛 董 11
- 12. V. K畉T LU畉N V i nh ng t鱈nh nng Entity Framework cung c p畛 畛 畉 ng th i gi炭p ch炭ng ta kh c ph c nh ng kh坦畛 畛 畉 畛 畛 khn hi n t i.畛 畉 S d ng Entity畛 畛 Framework ph叩t畛 tri n ph n m m畛 畉 畛 12
- 13. VI.DEMO 13
- 14. THANK YOU! 14
Editor's Notes
- #5: Nhin tren mo hinh ta de dang nhan thay EF duoc ke thua tu ADO.NET Cung cap them m畛t so tinh nang de mo hinh hoa du lieu Thanh nhung thuc the dang doi tuong lien ket voi nhau thong qua cac moi quan he