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
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.
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.
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.
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.
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.
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)
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,
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
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.
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,
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
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
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,
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
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
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,
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
when and where will that patch be available?
Thanks
Michael
The patch has been uploaded yesterday and it is available under the 'Downloads' section accessible via your account page.
Greetings,
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.