Telerik Data Access Benefits

2 posts, 0 answers
  1. Ricky
    Ricky avatar
    10 posts
    Member since:
    Apr 2012

    Posted 08 Apr 2014 Link to this post

    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);
                    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();

    Thank you

  2. Doroteya
    Doroteya avatar
    497 posts

    Posted 12 Apr 2014 Link to this post

    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.

    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
  3. DevCraft banner
Back to Top