What's the difference between DAO and DP patterns?

Question

What is the difference between Data Access Objects (DAO) and Data provider (DP) patterns?

I've read about them and it seems to me that they're the same except that .NET uses the data provider terminology.

score 2 · Accepted Answer · answered Aug 15 '16 at 05:20

Actually both specify an entity which exposes a set of customized methods to read from or write to a database.

Indeed the term 'DAO' is the more generic one to use. DP is a term introduced by Microsoft in their products to do the exactly same work. You can refer this for more detail about DPs.

score 0 · Answer 2 · answered Sep 28 '16 at 00:15

I usually use DataProvider when I just want to 'provide' a database in form of an instance. In this case, I don't have permission to write this instance back in database. I've just pick up these data to read.

But when I use DAO I'm allowing to permission to use all CRUD operations, as normal.

What's the difference between DAO and DP patterns?

2 Answers2