Devart Forums

Hi all,

I have a dotConnect for MySQL version 7.6.226. We updated the server Debian 6 Lenny to Debian 8 Jessie. The earlier created link to connect models are can not connect to the server. (They worked perfectly with the Debian Lenny)
First, I got the followed error message: After some searches I found a topic which said it will fixed if we add this line to the sshd_config file: I tried this. Since I edited this, I got the followed error message: I downloaded the demo version of dotConnect for MySQL 8.3 and created a new linkconnectmodel and it works without any error message.
If we create a new linkconnectmodel with my version (7.6 - I have license for this) then we can not connect and the error message is the same as above.

What can I do to make it works with the earlier projects?

Thanks in advance for any kind of help!

Hi Everybody,

I have a large project in which i separate the developing and runtime databases from each other. I solved this by creating Linq model to the developing database and when programming, I set the Connection string as follows:

#if DEBUG
ConnectionString = GetConnectionString("DeveloperConnectionString");
#else
ConnectionString = GetConnectionString("ReleaseConnectionString");
#endif


Of course, both ConnectionString is included in my app.config file.

By this, the connection string is set whether I interprete my projects in Debug mode, or in something else.

At time of interpretation, Connection string gets its proper value.

But the program always gets the value from the developing database, and never from the runtime database.

Finally, I got to the point why it is so: The connection determines only the fact, by which database I sign in to the SQL server, but if I modify or query another database from there, that is valid, and most likely it is determined in the model this way.

How could I change things so that I couldn't make separate models for runtime and for developing versions?

Best regards,

Imre

Pinturiccio wrote:

imre.dudas wrote:How should i convert my id_rsa file generated by ssh-keygen so that EntityFramework could use the key file and passthrase password when connecting?

You can use the id_rsa file in order to use a key with Entity Framework.

Please tell us what difficulties you encountered when working with a key in the id_rsa format.

I give an error: "invalid IV length" if i try id_rsa file.

Hello,

I want to connect to a MySQL database through SSH tunnel in the way that the SSH user would log in with a private key with passthrase.

I have a problem with this: If I want to convert the key to pem format for EntityFramework, the passthrase can be anything, it lets me login to the server. I wouldn't like it to be so. What I would like is that my code should contain the passthrase for the sake of higher safe. So far, If anyone could obtain the key, he could login to the server using SSH. That's the reason why I wouldn't like that.

What I did so far is the following:

On Linux server:

ssh-keygen -t rsa

I specify a passthrase when required.

Of course, I copy the public key into the file named authorized_keys .

I convert the rsa file to pem.

openssl rsa -in id_rsa -outform pem > server.key

This is the time when such a pem file is created that somehow contains the passthrase, because it is enough to replace the keys in order my client programs to login.

How should i convert my id_rsa file generated by ssh-keygen so that EntityFramework could use the key file and passthrase password when connecting?

Thank you in advance.

Best regards,

Imre

Thank you, great.

Hello,

How can I exactly use the SQLiteCrypt with Devart? I mean where should i exchange SQLite3.dll so that it would work properly also in Entity Developer ? Where do i need to write my license code I got to SQLiteCrypt? How is it possible to encode an existing database with it?

I couldn't find any description about these.

Thank you:
Imre

Hi to all,

In case of EntityFramework, how can I monitor if an user modified some data on the server so that I could know when to update my tables in the client application?

Hi to all,

I am making a simple registry program by using EntityFramework and dcMySQL 7.1.96. The MySQL database is located on a remote server. However, it was suggested if for some reasons the server is not available (due to connection problems, server maintenance, etc), the program should run in offline mode as well. In other words, users could reach and read data without the possibility of any modifications. Is there a better solution for this than manually copying data into an SQLite database in case of any modification and update, and in offline mode I can retrieve it from there?

Additionally, How can I tell from a database server if it is available or not in runtime, except for using SaveChanges() and we can see status from the result? I want to regularly monitor the status of the server in real time so that my program could automatically turn into offline mode if necessary.

Hello,

Thank you. I've chosen a second way.

Imre

Hi to all,

I am making a software that is able to handle local and remote databases. The local one is an SQLite , the remote is an PostgreSQL database. The handling of databases is implemented into a DLL.

As far as the structure, these two databases are the same: same tables, tables have the same columns.

My initial imagination was that I would make two models with Entity Developer. One modell would handle the first, the other would handle the second database. I got into the fault that since table names are the same, these two modells cannot fit into the same project, because duplications occure due to same names.

It is not hard to rename classes with a prefix in the following way: lTable1, lTablle2, … rTable1, rTable2, or use different namespaces, but I would avoid this method if possible.

Is there any regular solution for this?

Thanks:
Imre

Hello,

I have written a little application, that require .NET 2.0. I don't want to use latest .NET, so I use DataSet technology.

I generated my DataSet with DataSet wizard, add, modify rows programmatically, but the Delete method (ds.Connections.RemoveConnectionsRow(Row)) is not work. My table name is Connections .

I call Update method too.

I have checked events. ConnectionsRowDeleting was called, and the row is ok in event args. The ConnectionsRowDeleted method was not called.

What did I wrong?

AndreyR wrote:Could you please post here the script of the table you have encountered an error with the wrong Entity Key generation?

I created a test on my server, and create a model. You can access to my database with this model. It's a simple test, but the entity key is false default.
The table creation SQL script is
create table testtable
(
test_id serial,
test_note varchar(100)
);

http://dl.dropbox.com/u/3968115/Test.zip

Regards:
Imre

Thank you. It's ok.

If i remember good, in the last versions, entity key checked automatically.

Hello,


I generated DataContext models from PostgreSQL database with Entity Developer new version. I can't insert, update and delete all of my tables in my program.

AuthorizationDataContext dc = new AuthorizationDataContext(connectString);
FirstChars f = new FirstChars();
...
dc.FirstChars.InsertOnSubmit(f);

And give me an exception:
System.InvalidOperationException: Can't perform Create, Update or Delete operations on 'Table(FirstChars)' because it is read-only or does not have identity members.
Devart.Data.Linq.Table.l()
Devart.Data.Linq.Table.c(Object A_0, Boolean A_1)
Devart.Data.Linq.Table`1.InsertOnSubmit(TEntity entity)

FirstChars is a simple table with three character varring fields: FirstThreeCharacters, SoftwareName, SoftwareVersion.

The role that i used in ConnectString have got privileges these operations in database.

Best Regards:
Imre

AndreyR wrote:We have fixed the autoincrement problem in SQLite. The new build will contain the fix.

Thank you. You are working very fast.