Telerik Data Access Benefits

[Ricky]

Hi, I am currently evaluating the Telerik Data Access,
I commonly used a stored procedure to do Select and Save ( Update, Insert ,Delete) to database.
I checked Telerik Data Access will generate the method and return the class for the stored procedure that return a Data Set.
other than that , is there any other benefits using Telerik Data Acesss, compared to if I created the method using simple Data SQL Client connection like shown below ?


 SqlConnection sqlConn = new SqlConnection(sqlConnect);
                sqlConn.Open();
                SqlCommand cmdFileInfo = new SqlCommand();
                cmdFileInfo.Connection = sqlConn;
                cmdFileInfo.CommandText = "dbo.uspInsFile;
                cmdFileInfo.CommandType = CommandType.StoredProcedure;
                cmdFileInfo.Parameters.Add(new SqlParameter("@Files", fileXML));
                cmdFileInfo.Parameters.Add(new SqlParameter("@UserLogin", userLogin));
                int returnID = cmdFileInfo.ExecuteNonQuery();
                sqlConn.Close();

Thank you

[Doroteya]

Hello Ricky,

Thank you for your interest in Telerik Data Access.

Indeed, Telerik Data Access can generate domain methods and the corresponding return shapes for you. In this scenarios it utilizes the Domain Method Editor which is a part of our integration in Visual Studio. Some of the features that also participate in this set and contribute to our flexible code generation capabilities are Visual Designer, project and item templates, a large set of wizards and dialogues.

The design time with Telerik Data Access also supports a Fluent Mapping API that allows you to create and customize models by writing only code.

Additionally, Telerik Data Access also offers a very powerful runtime features and performance optimizations like Lazy Loading, Automatic Change Tracking, Bulk Select, Update and Delete.

Moreover, in this blog post, you can find several reasons why you can consider Telerik Data Access for your projects.

I hope this helps. In case you have additional questions, do not hesitate to get back to us.


Regards,
Doroteya
Telerik