OpenAccess ORM express with Visual Studio Express

17 posts, 0 answers
  1. Rafael
    Rafael avatar
    8 posts
    Member since:
    Dec 2007

    Posted 22 Jan 2009 Link to this post

    Hi,

    My question is about using OpenAccess ORM express with Visual Studio Express Editions. As far as I know the wizards are specific designed for Visual Studio (“official editions”), but if we did the wizard job by hand. Could we use OA OEM Exp. In Visual Studio Express?

    Thanks in advance.

  2. Peter Brunner
    Admin
    Peter Brunner avatar
    89 posts

    Posted 22 Jan 2009 Link to this post

    Hello Rafael,

    thanks for asking. OpenAccess (Full, Trial, Express) does not support Visual Studio Express, because Microsoft does not allow 3rd parties to integrate into the Express version.

    Best regards,
    Peter Brunner
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. DevCraft banner
  4. Rafael
    Rafael avatar
    8 posts
    Member since:
    Dec 2007

    Posted 22 Jan 2009 Link to this post

    Hello Peter,

    Thank you for your replay. I was thinking about doing the entire job manually, I mean putting the necessary references to libraries (like Telerik.OpenAcces.dll) and make the changes to App configuration file … etc. But perhaps the problem will be with the Open Access ORM Enhancer, because it will not be call it by the Visual Studio ID and I should do it manually (command line).

    In any case I have Visual Studio 2008, but for the people that can’t afford it (or don’t want to buy it) these could be a way to test your product. I will try it (I don’t promise when) and I’ll share with yours the results.

    Best regards.

  5. Peter Brunner
    Admin
    Peter Brunner avatar
    89 posts

    Posted 22 Jan 2009 Link to this post

    Hi Rafael,

    thanks for the idea and proposed effort, but actually we have many wizards and will have even more in the future to simplify data access by ORM. So most-likely you won't achieve any environment without Visual Studio which would let you test OpenAccess.

    Anyway, there is a way to do something with the enhancer addressing what you mentioned. Please let us konw, if just this would help you also.

    Regards,
    Peter Brunner
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  6. Peter Brunner
    Admin
    Peter Brunner avatar
    89 posts

    Posted 23 Jan 2009 Link to this post

    Hi Rafael,

    some additional information now:

    There is an integration into the MSBuild framework available which should be usable in the VS Express edition too. Please see the topic MSBuild in the documentation for more information on how to set this up.

    Best wishes,
    Peter Brunner
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  7. Eiron Cervantes
    Eiron Cervantes avatar
    2 posts
    Member since:
    Jul 2009

    Posted 04 Aug 2009 Link to this post

    Hi, I want to know if i can,t connet a firebird's database in visual studio 2008, i'm using orm express
  8. Peter Brunner
    Admin
    Peter Brunner avatar
    89 posts

    Posted 04 Aug 2009 Link to this post

    Hello Eiron,

    Yes, Telerik OpenAccess ORM Express supports Firebird; in Visual Studio 2005 or 2008
    (not in the Visual Studio Express editions though as mentioned before in this thread).

    See also our comparison of the 2 Telerik OpenAccess versions available.

    Greetings,
    Peter Brunner
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  9. Eiron Cervantes
    Eiron Cervantes avatar
    2 posts
    Member since:
    Jul 2009

    Posted 04 Aug 2009 Link to this post

    Thanks..
    I want to buy this product but...

    I'm using visual studio 2008, ORM Express

    I have a problem.. when i try to connect to firebird's database it shows..
     

    test connect with the following URL:

    Backend=firebird;Server=192.168.7.153;Database=D:\base de datos\newsubdb.fdb;Driver=;Integrated Security=False;USER=SYSDBA;PASSWORD=kernel3;

    The connection could not be established. The reason was:

    Unknown failure

    Exception: Telerik.OpenAccess.Exceptions.DataStoreException

    Cause: Telerik.OpenAccess.RT.sql.SQLException: Dynamic SQL Error

    SQL error code = -204

    Table unknown

    TESTTABLE12345678

    No message for error code 336397208 found.

    en Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()

    en OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()

    en OpenAccessRuntime.Relational.RelationalQueryResult.createFetchResult(Connection conParam, SqlDriver sqlDriver, Boolean scrollableParam, FetchSpec fetchSpec, RelationalCompiledQuery relationalCompiledQuery, RelationalStorageManager storageManager, Object[] paramVals, Int32 fetchSize, Int32 maxRows)

    Where: en Telerik.OpenAccess.SPI.Backends.ThrowException(Exception e)

    en Telerik.OpenAccess.RT.ExceptionWrapper.Throw()

    en OpenAccessRuntime.storagemanager.logging.LoggingStorageManager.fetchNextQueryResult(ApplicationContext context, RunningQuery runningQuery, Int32 skipAmount)

    en OpenAccessRuntime.DataObjects.UnsynchronizedPMProxy.getNextQueryResult(QueryResultWrapper aQrs, Int32 skipAmount)

    en OpenAccessRuntime.DataObjects.ForwardQueryResult.get_Item(Int32 indexParam)

    en Telerik.OpenAccess.RT.ListEnumerator.setCurrent(Int32 _pos)

    en Telerik.OpenAccess.RT.ListEnumerator.Move(Int32 relative)

    en Telerik.OpenAccess.RT.ListEnumerator.MoveNext()

    en Telerik.OpenAccess.Sdk.Design.Wizards.EnableProject.TestConnection.testCreateConnection()

    -----Inner Exception -----

    Exception: Telerik.OpenAccess.RT.sql.SQLException

    Cause: Dynamic SQL Error

    SQL error code = -204

    Table unknown

    TESTTABLE12345678

    No message for error code 336397208 found.

    Where: en Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()

    en OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()

    en OpenAccessRuntime.Relational.RelationalQueryResult.createFetchResult(Connection conParam, SqlDriver sqlDriver, Boolean scrollableParam, FetchSpec fetchSpec, RelationalCompiledQuery relationalCompiledQuery, RelationalStorageManager storageManager, Object[] paramVals, Int32 fetchSize, Int32 maxRows)

  10. Ady
    Admin
    Ady avatar
    589 posts

    Posted 05 Aug 2009 Link to this post

    Hi Eiron Cervantes,

     Thanks for pointing that out. This is a bug in the 'Test Connection' feature but you should be able to connect nevertheless. We have fixed this bug and the fix will be available in the next patch.

     Did you try creating Persistent classes and then the schema (Forward mapping) or creating classes from your database (Reverse mapping)? It should work both ways.

     Do try it out and let us know about your progress.

    Regards,
    Ady
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  11. Denis Vulinovich
    Denis Vulinovich avatar
    29 posts
    Member since:
    Jun 2009

    Posted 10 Aug 2009 Link to this post

    Hi Ady,

    I've got exactly the same problem as Eiron. Forward Mapping doesn't work - it doesn't change the database schema.

    I can add a connection to the database in Server Explorer, and when I build and run the application there are no errors, but the database doesn't change.
  12. Ady
    Admin
    Ady avatar
    589 posts

    Posted 11 Aug 2009 Link to this post

    Hi Denis Vulinovich,

     Can you verify the 'Update Database' project property (Select the project in Solution Explorer and press F4)  of the project you build. Usually the DAL project should be responsible for updating the schema and the property should be set to true.

    Best wishes,
    Ady
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  13. Denis Vulinovich
    Denis Vulinovich avatar
    29 posts
    Member since:
    Jun 2009

    Posted 11 Aug 2009 Link to this post

    Hi Ady,

    Yes, the UpdateDatabase property is set to true, along with the Enhancing property.

    I've implemented the project in section 2.2 of the "OpenAccess ORM Made Easy" document from your website, which has a single Customer class. Here's the App.config file:

    <?xml version="1.0"?> 
    <configuration> 
      <configSections> 
        <section name="openaccess" type="Telerik.OpenAccess.Config.ConfigSectionHandler, Telerik.OpenAccess.Config, Version=1.0.0.0, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342" requirePermission="false" /> 
      </configSections> 
      <openaccess xmlns="http://www.telerik.com/OpenAccess"
        <references /> 
        <connections> 
          <connection id="MyDatabaseConnection"
            <databasename>MyDatabase</databasename> 
            <servername>localhost</servername> 
            <integratedSecurity>False</integratedSecurity> 
            <user>sysdba</user> 
            <password>vsined</password> 
            <backendconfigurationname>firebirdConfiguration</backendconfigurationname> 
          </connection> 
        </connections> 
        <backendconfigurations> 
          <backendconfiguration id="firebirdConfiguration" backend="firebird"
            <mappingname>firebirdMapping</mappingname> 
          </backendconfiguration> 
        </backendconfigurations> 
        <mappings current="firebirdMapping"
          <mapping id="firebirdMapping"
            <namespace name="Firebird_OpenAccess"
              <class name="Customer"
                <field name="customerName" null-value="exception"
                  <extension key="db-column"
                    <extension key="db-length" value="30" /> 
                  </extension> 
                </field> 
                <field name="customerNumber" null-value="exception" /> 
              </class> 
            </namespace> 
          </mapping> 
        </mappings> 
      </openaccess> 
    </configuration> 

    Regards,
    Denis
  14. Ady
    Admin
    Ady avatar
    589 posts

    Posted 13 Aug 2009 Link to this post

    Hi Denis Vulinovich,

     For firebird you need to specify the fully qualified file name of the database (.fdb) file in the app.config.
    Please modify that and let us know if the database gets created successfully.

    Sincerely yours,
    Ady
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  15. Denis Vulinovich
    Denis Vulinovich avatar
    29 posts
    Member since:
    Jun 2009

    Posted 13 Aug 2009 Link to this post

    Hi Ady,

    Yes, it's working now.

    But it didn't work at first because it didn't create the Customer table when I built the project. But then I added an index to the class and after that it started working!?

    Thanks for your help.

    Denis
  16. Ady
    Admin
    Ady avatar
    589 posts

    Posted 14 Aug 2009 Link to this post

    Hello Denis Vulinovich,

     If the fully qualified path is not specifed, but only the database name, Firebird creates the schema in it's working folder .(Windows\System32). The schema update task did not detect a change the first time and hence no changes were made. When you added an index, a migration step was initiated and the schema was rightly created.

     Do feel free to get back to us in case you have further questions.

    Kind regards,
    Ady
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  17. Michael Winter
    Michael Winter avatar
    7 posts
    Member since:
    Jun 2009

    Posted 25 Aug 2009 Link to this post

    Hi,
    when and where will that patch be available?

    Thanks
    Michael
  18. Ady
    Admin
    Ady avatar
    589 posts

    Posted 27 Aug 2009 Link to this post

    Hi Michael Winter,

     The patch has been uploaded yesterday and it is available under the 'Downloads' section accessible via your account page.

    Greetings,
    Ady
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Back to Top
DevCraft banner