Current filter:
                                You should refresh the page.
                                0
                                Young Lim 06.17.2012

                                  • My app is currently using ADO.NET with SQL commands used everywhere.


                                    I read thru XPO and find that it is quite involve converting it to XPO. Can I still use SQL Commands (SELECT, UPDATES etc) if I convert to XPO?


                                    My only interest in converting to XPO is to use grid "server load". From my understanding, to get the performance, I must use XPO. Is that correct?

                                Leave a Comment
                                You must  log in  or  register  to leave comments

                                2 Solutions

                                Creation Date
                                Rating
                                Importance                                 Sort by
                                0
                                Anatol (DevExpress Support) 06.18.2012

                                Hello Young,

                                As far as I understand, you are interested in the Server Mode feature. There are various technologies that can be utilized to enable this feature: XPO, LINQ, and Entity Framework. Please refer to the Server Mode help topic for additional information.
                                If you are interested in XPO, I believe that the following documentation article will be helpful for a start: Querying a Data Store. I also suggest that you read the XPO Tutorial to get a clear imagination about this technology.
                                You can also execute SQL queries in XPO directly, as Brendon suggested, but this approach cannot be used together with Server Mode.

                                Leave a Comment
                                You must  log in  or  register  to leave comments
                                0
                                Brendon Muck [DX Squad/MVP] 06.17.2012

                                You can execute queries and stored procedures via Xpo, but only v2012 will return the metadata (such as column names) with the result record set. Also, the direct query method does not support parametrized queries unless you are using the newest version.


                                For example, you can execute a standard Sql query using the Session.ExecuteQuery method:

                                http://documentation.devexpress.com/#XPO/DevExpressXpoSession_ExecuteQuerytopic


                                The Session class also has methods to execute a scalar query or a stored procedure.


                                If you were to just execute hard-coded SQL strings or stored procedures, I don't think you'd get much benefit out of the Xpo product, unless you want your application to work with multiple database platforms. The real value of the Xpo product is that you can work with objects in a relational manner.

                                • Young Lim 06.17.2012

                                  Thanks Brendan.

                                  The only "feature" that I am interested in in XPO is the claimed performance when loading grid in ASP.NET. Other features are of no value to my app.

                                  Is there any other option to use to get the performance gain in loading data into the grid without using XPO?

                                • Brendon Muck [DX Squad/MVP] 06.17.2012

                                  What performance gain are you referring to? Xpo has more overhead than using standard ADO.NET, so unless you're using a cached datalayer or server-mode, I'm not sure you'd see that much performance.

                                • Young Lim 06.21.2012

                                  Thanks.

                                  I really don't want to change to XPO and still to standard ADO.NET. I just want to use the performance in the grid.

                                  Is this server mode? Do I have to change my code for server mode?

                                • Anatol (DevExpress Support) 06.21.2012

                                  The only XtraGrid-related way to increase performance is to use Server Mode. Please see my answer on 6/18/2012 to learn how to support this feature in your application. There are also other ways to improve performance - optimize queries, apply database indices, etc., but they are not related to our components.

                                Leave a Comment
                                You must  log in  or  register  to leave comments
                                You must  log in  or  register  to leave an answer

                                Is your intention to post an answer to your own question?

                                • If so, then proceed.
                                • If you simply wanted to post additional information, ask for further clarification, or to just say "Thanks!", please click Leave a Comment.
                                • If you wish to edit your original question, please use the Edit button in the Toolbox at the top right corner of that entry.