sql datasource and object datasource differences ?

Question

What is the difference between Sql datasource  Object datasource and Entity datasource ?

Rajeesh Menoth · Answer

Hi Kavi Answer for similar thread in Asp.Net Forum : SqlDataSource uses straight ADO.NET under the covers. That means it writes all the raw SQL connection data and commands for you and controls them on a page so you don't have to worry about them. If you are only using SQL and you don't care to manually control anything this is an ok choice. EntityDataSource is exactly what it says it controls Entity objects using the LINQ to Entities technology. It represents an EDM (Entity Data Model) and will handle all the context calls and submissions for you essentially ObjectDataSource is a wrapper that will control any Object you want for CRUD operations. If you have a custom access object you wrote yourself and need it to do custom code then that's your choice for ease of access. This control is also used for other types of controls such as the ReportViewer. The ReportViewer has what's called ReportDataSources and they generally wrap ObjectDataSources under the covers. Reference : http://forums.asp.net/t/1876836.aspx?When+do+I+use+SqlDataSource+vs+EntityDataSource+vs+ObjectDataSource

Joginder Banger · Answer

#suraj Binorkar I admire your answer but i want know what is the source of this answer. Thanks for sharing valuable information.

Suraj Binorkar · Answer

1. SqlDataSource is two-tier in nature where as ObjectDataSource supports three-tier architecture. 2. SqlDataSource requires very small amount of coding to connect with database. For ObjectDataSource more coding is required to build data access class. 3. SqlDataSource not support full encapsulation. ObjectDataSource supports full encapsulation. 4. SqlDataSource requires complete connection string to connect with database. ObjectDataSource exposes TypeName attribute that is a name of middle layer class may used to perform database related operations. Data access class must be placed in App_Code directory. 5. Caching is same for both controls but ObjectDataSource control fires NotSupported exception if return type of SelectMethod is other than DataSet.

Ritesh Singh · Answer

Hi Please visit below link: http://www.upsizing.co.uk/Art37_VSDataSources.aspx Note: Please accept the answer if it help you and answer your question. Thanks & Regards Ritesh