There are many connecton managers ,the most popular connection managers are ADO.NET,OLEDB
so 'when to choose what' is important.when you need speed, use oledb else use Ado.Net .It Provides greater flexibility where you can execute different scripts with parameters but marshaling can be overhead which gives ado.net that extra flexibility
Another important connection manager which is less known is Multi Flat-file connection manager,it allows to load multiple files.It brings major performance benefits as everything is executed within a data flow
so 'when to choose what' is important.when you need speed, use oledb else use Ado.Net .It Provides greater flexibility where you can execute different scripts with parameters but marshaling can be overhead which gives ado.net that extra flexibility
Another important connection manager which is less known is Multi Flat-file connection manager,it allows to load multiple files.It brings major performance benefits as everything is executed within a data flow
No comments:
Post a Comment
Note: only a member of this blog may post a comment.