Devart Forums

FlorianDahn

*push*

Due to the latest update I hoped you got this already, sadly you didnt. How long will you need to add?
Cause im starting a new project right now.

Thanks

FlorianDahn

Hey!

I'm having some trouble accessing a wordpress database posts inside my blazor application.

When loading the Post_content im getting it but with a wrong encoding of german characters.
Looks like this:

Zur Einhaltung der Klimaziele m�ssen bis 2050 mehrere Millionen W�rmepumpen installiert werden!

The character id is 65533 .

Charset is utf8mb4 and collation is utf8mb4_0900_ai_ci

Not sure if I have to change the encoding somewhere.

Thank you
Warm regards
Florian Dahn

FlorianDahn

Shalex wrote: ↑Tue 03 May 2022 16:33 There is no such functionality in the DataContext class but you can use Entity Developer for this purpose either via design time using Update To Database Wizard (copy update script instead of applying it) or via the console version of the tool calling "ed Get-Update-Script" (https://www.devart.com/entitydeveloper/ ... r_app.html).

Ok, thanks!

Issue here is right now, it seems that only for the Create method I can specify a ConnectionString.
I'm having a server with multiple versions (and names) of the database, would be great to easily change which database to check and generate the update script.

Thank you

FlorianDahn

Shalex wrote: ↑Tue 03 May 2022 17:16 Thank you for your suggestion. We will improve the behavior to set Auto Generated Value=True and Auto-Sync=OnInsert for UNIQUEIDENTIFIER DEFAULT (newid()) columns automatically.

Perfect! Thank you!

FlorianDahn

Shalex wrote: ↑Thu 28 Apr 2022 16:32 The investigation is in progress. An approximate timeframe for the fix is one month.

Great, thanks for the follow up!

FlorianDahn

Hey,

when using an int or bigint type in an sql database column and importing into a model the column properties will be set for "Auto Generated Value" to true and for "Auto-Sync" to "OnInsert".

Would be great when choosing uniqueidentifier (GUID) in an sql database and importing into a model both properties are also set when the default value of the column is "newid()".

Maybe you got this already, but I havent found it yet.

Thank you!
Warm regards
Florian Dahn

FlorianDahn

Shalex wrote: ↑Tue 15 Mar 2022 19:01 Thank you for the test project. We will investigate the issue and notify you about the result.

Hey!

just wanna ask if you got some news on this thing?

Thanks!

FlorianDahn

Hey!

I have seen that you got a CreateDatabase/DeleteDatabase method in the DataBaseContext.

Is there any way to compare the database model (lqml) to the database and get a list of differences ?
Missing tables, column changes, etc?

And optional an update method, to update the database where you can pass the result of the method from above ?

Thank you!

FlorianDahn

Shalex wrote: ↑Tue 08 Mar 2022 15:32 Please send us a test project with your model so that we can reproduce the issue in our environment.

Hey!

Sorry for the delay.
I had now prepared a test project, which raises the same exception.
I'll sent it to you by the provided link.

Thanks and hope to hear back from you soon!
Warm regards
Florian Dahn

FlorianDahn

Shalex wrote: ↑Tue 08 Mar 2022 15:32 Please send us a test project with your model so that we can reproduce the issue in our environment.

I'll prepare something for you in the next 1-2 days.

FlorianDahn

Hey!
I tried to build a database installer and used the CreateDatabase method of the DataContext.

But im receiving an error that a ForeignKey can not be installed due to missing table.
So it seems it tries to install tables and keys at the same time, which is not got as it looks like.

Would it be possible to install the tables first and then the keys ?

When using IgnoreErrors=true it install all tables which does not have a foreign key.

Thanks as always!

Warm regards
Florian Dahn

FlorianDahn

I downloaded and installed that Windows 10 Update KB5006670 again and can confirm that this issue is now fixed.
Thank you guys!
Warm regards
Florian Dahn

FlorianDahn

UPDATE: I uninstalled the first Windows 10 Update KB5006670 and Now everything (the Designer in VS2019 and the extern Entity Designer) is working again as expected. So take care and take a look what it has to do with this update.

FlorianDahn

Hey community,

today, i'm comming into some curious issue. I used the Designer inside of VS 2019 and it worked just fine.
Later the day I updated VS2019 to the current version of 16.11.5 (Before I was on 16.11.4)

Since then, the Designer will not open anymore. Sometimes it just opened the text/xml editor.

On the first try when using "Open with", just to be sure, im getting the message: (roughly translated) An element with the same key has been added already.

Nothing happens. It just openes that same "Open with" dialog. Second try doesn't do anything.

I updated the LinqtoSql Tools Pro to latest version and it doesn't helped. I want to just mention, that during installation it will remove the old version, so another unistall will not be necessary, hopefully.

Thank you!
Warm regards
Florian dahn

PS: I started the Entity Developer UI and directly after starting it crashed. I reported it by mail. Maybe it helps.
PS2: I also installed 2 windows 10 updates today (KB5006670 and KB5005539), I will uninstall both now and let you know.

FlorianDahn

For everbody else having the same "issue".
I build some generic extension methods which will help here "automatically".

Code: Select all

public static List<T> WhereOrInserted<T>(this Table<T> table, Expression<Func<T, bool>> predicate)
	where T : class
{
	var result = table.Where(predicate).ToList();
	if (result != null && result.Count != 0)
		return result;

	result = table.Context.GetChangeSet().Inserts.Where(a => a.GetType() == typeof(T))
								.Select(a => a as T)
								.ToList();

	return result;
}

public static T FirstOrInserted<T>(this Table<T> table, Expression<Func<T, bool>> predicate)
	where T : class
{
	var result = table.First(predicate);
	if (result != null)
		return result;

	result = table.Context.GetChangeSet().Inserts.Where(a => a.GetType() == typeof(T))
								.Select(a => a as T)
								.First();

	return result;
}

public static T FirstOrDefaultOrInserted<T>(this Table<T> table, Expression<Func<T, bool>> predicate)
	where T : class
{
	var result = table.FirstOrDefault(predicate);
	if (result != null)
		return result;

	result = table.Context.GetChangeSet().Inserts.Where(a => a.GetType() == typeof(T))
								.Select(a => a as T)
								.FirstOrDefault();

	return result;
}

Devart Forums

Search found 26 matches

Re: Automatic Property Set for GUID

MariaDB (Mysql) issue with encoding german characters

Re: IntegrityCheck/Update methods

Re: Automatic Property Set for GUID

Re: CreateDatabase does not work with ForeignKeys

Automatic Property Set for GUID

Re: CreateDatabase does not work with ForeignKeys

IntegrityCheck/Update methods

Re: CreateDatabase does not work with ForeignKeys

Re: CreateDatabase does not work with ForeignKeys

CreateDatabase does not work with ForeignKeys

Re: Error on opening Designer (lqml)

Re: Error on opening Designer (lqml)

Error on opening Designer (lqml)

Re: Batch processing issue