This is a migrated thread and some comments may be shown as answers.

OpenAccess ORM express with Visual Studio Express

16 Answers 364 Views
Data Access Free Edition
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Rafael
Top achievements
Rank 1
Rafael asked on 22 Jan 2009, 09:32 AM

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.

16 Answers, 1 is accepted

Sort by
0
Peter Brunner
Telerik team
answered on 22 Jan 2009, 10:04 AM
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.
0
Rafael
Top achievements
Rank 1
answered on 22 Jan 2009, 01:10 PM

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.

0
Peter Brunner
Telerik team
answered on 22 Jan 2009, 02:14 PM
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.
0
Peter Brunner
Telerik team
answered on 23 Jan 2009, 11:07 AM
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.
0
Eiron Cervantes
Top achievements
Rank 1
answered on 04 Aug 2009, 02:43 PM
Hi, I want to know if i can,t connet a firebird's database in visual studio 2008, i'm using orm express
0
Peter Brunner
Telerik team
answered on 04 Aug 2009, 02:50 PM
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.
0
Eiron Cervantes
Top achievements
Rank 1
answered on 04 Aug 2009, 05:17 PM
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)

0
Ady
Telerik team
answered on 05 Aug 2009, 11:57 AM
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.
0
Denis Vulinovich
Top achievements
Rank 1
answered on 10 Aug 2009, 06:04 PM
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.
0
Ady
Telerik team
answered on 11 Aug 2009, 01:24 PM
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.
0
Denis Vulinovich
Top achievements
Rank 1
answered on 11 Aug 2009, 06:50 PM
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
0
Ady
Telerik team
answered on 13 Aug 2009, 12:44 PM
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.
0
Denis Vulinovich
Top achievements
Rank 1
answered on 13 Aug 2009, 06:55 PM
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
0
Ady
Telerik team
answered on 14 Aug 2009, 03:07 PM
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.
0
Michael Winter
Top achievements
Rank 1
answered on 25 Aug 2009, 07:45 AM
Hi,
when and where will that patch be available?

Thanks
Michael
0
Ady
Telerik team
answered on 27 Aug 2009, 03:44 PM
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.
Tags
Data Access Free Edition
Asked by
Rafael
Top achievements
Rank 1
Answers by
Peter Brunner
Telerik team
Rafael
Top achievements
Rank 1
Eiron Cervantes
Top achievements
Rank 1
Ady
Telerik team
Denis Vulinovich
Top achievements
Rank 1
Michael Winter
Top achievements
Rank 1
Share this question
or