Devart Forums

StanislavK

With Visual Studio 2010 and 2012, T4 Editor is added as an extension package. As Visual Studio 2008 does not support extension packages, T4 Editor is just installed as one of studio's file editors. To ensure T4 Editor was installed, you can do one of the following:
1) check the 'Devart T4 Editor' item in the Start menu;
2) use the 'Open With' menu item on a template file in Visual Studio; if T4 Editor is installed, there should be the 'Devart Template Editor' option available.

As for the problem with Entity Developer, please try re-installing the Entity Developer trial. If the problem persists, please specify it in more details; e.g., please specify the following:
- whether Entity Developer hangs in both Visual Studio and standalone modes;
- what exact screen it is showing;
- whether this problem occurs only when trying to open an existing model or when creating a new one as well.

StanislavK

Please ensure that you used the proper installation of T4 Editor: it has a separated installation package for each Visual Studio version (2008, 2010, and 2012). You can download the one for Visual Studio 2008 from
http://www.devart.com/t4-editor/download.html

If you are encountering any problems with this, please describe them in more details. For example, saying that T4 Editor doesn't work under VS 2008, do you mean that there is no T4 Editor item in the VS menu, or, e.g., that you are getting an exception when working with a template?

As for Entity Developer Express, it does not provide the template editing functionality:
http://www.devart.com/entitydeveloper/editions.html

StanislavK

Please specify the exact product you are evaluating (this can be either LinqConnect Professional or dotConnect for Oracle Professional).

Generally, to evaluate either product on a machine where this product is not installed, you have to add a resource with the technical license into your application.

As for dotConnect for Oracle, the detailed information about technical licensing is available in our documentation:
http://www.devart.com/dotconnect/oracle ... nsing.html

For LinqConnect Trial, the process is generally the same, though you should license the OracleDataProvider object instead of OracleConnection. You can also refer to the following forum topic for more details:
http://forums.devart.com/viewtopic.php?t=19773

Feel free to contact us if you encounter any problems with this.

StanislavK

Could you please describe this scenario in more details? In particular, please specify how the DataContext and DbLinqDataSource objects are created.

If possible, send us a sample application, so that we are able to analyze the situation in more details.

StanislavK

As far as I understand, you performed these actions on the same DataContext instance. Am I correct? If yes, this is an expected behaviour: DataContext caches the inserted entities and is unaware that they were in fact deleted. So, when you insert the same object again, DataContext raises an exception, as this entity is already available in context's cache.

A general recommendation is to create one DataContext per unit of work, and dispose it as soon as this unit of work is finished:

Code: Select all

// Insert an entity for the first time:
MyDataContext context = new MyDataContext();
context.MyTable.InsertOnSubmit(
  new MyEntity () { ... }
);
context.SubmitChanges();

// Delete the corresponding row.

// Insert an entity with the same key again:
context = new MyDataContext();
context.MyTable.InsertOnSubmit(
  new MyEntity () { ... }
);
context.SubmitChanges();

StanislavK

We've answered you by mail, please confirm that you've received our letter.

StanislavK

At the moment, you can use only the LinqConnect ORM on the Metro platform. For more information on this, please see the LinqConnect for Metro overview:
http://www.devart.com/linqconnect/metro ... nnect.html

StanislavK

Could you please describe the purpose of using the same context in multiple threads? Generally, the DataContext object is not thread-safe, at least because the underlying connection object is not.

Please describe this scenario in more details, so that we are able to further investigate the issue. If possible, please send us a small test project with which the problem can be reproduced.

StanislavK

Thank you for the report, we have reproduced this behaviour. We will analyze the possibility of removing the second condition of the join.

StanislavK

Thank you for sharing. Yes, this way should be working just as well.

The only possible difference should be the order of conditions in the WHERE clause of the resulting SQL query (the way you described, the 'IsPartner' condition always comes last).

StanislavK

We've sent you the sample again. Please check that the letter is not blocked by your mail filter.

If there are any problems with this, please specify some other mail address where we can send the sample (you can contact us at 'support at devart dot com' for this).

Also, there were multiple fixes related to performance since the 3.1.43 version of LinqConnect. Please try upgrading to the latest version of LinqConnect or dotConnect for Oracle, and tell us if this helps.

If it doesn't, please send us the profiling information and specify the exact version and product you are using.

StanislavK

We've sent a sample to you, please check that the letter is not blocked by your mail filter.

StanislavK

The Professional edition of LinqConnect includes the Express edition of dotConnect for SQLite. Thus, you don't have to buy dotConnect for SQLite to work with SQLite databases via LinqConnect. JIC: you can purchase any combination of Team and/or Single licenses, as long as they cover the total number of developers working with LinqConnect.

See the edition matrices of both products for the details:
http://www.devart.com/linqconnect/editions.html
http://www.devart.com/dotconnect/sqlite/editions.html

As for using the same model with different DBMSs, you may be interested in using the file mapping instead of the attribute one. Check, e.g., the following forum topic for the details:
http://forums.devart.com/viewtopic.php?f=31&t=24588

StanislavK

Generally, SQLiteDataProvider works with dotConnect for SQLite connections (i.e., objects of the Devart.Data.SQLite.SQLiteConnection type) only.

To use some other connections (e.g., those from the System.Data.SQLite library) in your LinqConnect models, you can try implementing a descendant of DataProvider or SQLiteDataProvider. Some details on implementing such a class are discussed in the following topic:
http://forums.devart.com/viewtopic.php?f=31&t=25495

Also, could you please specify the purpose of using System.Data.SQLite.SQLiteConnection in your model?

StanislavK

We have reproduced the problem with setting the output parameter value (in our environment, no new value is assigned to it after executing the command). We will analyze this issue and inform you about the results.

At the moment, you can use the workaround with creating an OracleParameter descendant.

Devart Forums

Search found 1710 matches

Re: T4Editor and Entity Developer together?

Re: T4Editor and Entity Developer together?

Re: Using evaluation version on test server

Re: dbLinqDataSource.ContextCreating - Object does not match target type.

Re: LinqConnect Professional Version 4.1.184 (07-Feb-2013) - problem when delete.

Re: Establishing connection pool

Re: metro application EF 6 and dbContext

Re: LinqConnect Professional Version 4.1.184 (07-Feb-2013) - access from two and more thread.

Re: Performance issue with LEFT OUTER JOIN on a CHAR field

Re: Extend Database with new objects

Re: Performance issue with lazy loading

Re: Create/Extend entities at runtime?

Re: Possible DataProvider's

Re: Possible DataProvider's

Re: How to create a Clob output parameter