Devart Forums

Zero-G.

Hey

In mySQL 8, there is a Warning, when creating a field with integer incl. precision.
"Warning: #1681 Integer display width is deprecated and will be removed in a future release."

Will there be a possibility to create backups from older versions, which take care about this warning!?
THX a lot in advance

Zero-G.

Hey

Using the .Net Core Version of your mySQL Product
I maybe found a bug in the MySqlDependency class
I want to add a CommandDependency by using a list, what works really fine:

Code: Select all

  locListOfTables.ForEach(Sub(locItem)
                                    Dim locCommand As New MySqlCommand With {.Connection = myConnection,
                                                                             .CommandText = String.Format("Select * from {0}", locItem}

                                    Dim locTableCommand = locCommand

                                    locDependency.AddCommandDependency(locTableCommand)
                                End Sub)

The problem with this code is, that Visual Studio says, that the Select command is not safe: https://docs.microsoft.com/en-us/visual ... ew=vs-2019

This is, why I tried to add parameterized Query to the CommandDependency:

Code: Select all

locListOfTables.ForEach(Sub(locItem)
                                    Dim locCommand As New MySqlCommand With {.Connection = myConnection,
                                                                             .CommandText = "Select * from :table"}

                                    locCommand.Parameters.Add("table", locItem.ToString)

                                    Dim locTableCommand = locCommand

                                    locDependency.AddCommandDependency(locTableCommand)
                                End Sub)

But then, then OnChange event get's never hit. In the first solution, everything works fine.
Could you please check this
THX a lot

Zero-G.

Hey

Is there any tutorial, how I could implement the MySQLDependency Class https://www.devart.com/dotconnect/mysql ... dency.html
with Entity Framework!?

Would be happy for every kind of help

THX

Zero-G.

Hey
At the Moment I am using mySQL Server 5.5 for my Software.
I connect via Connection String without specifing any collation. Everything works fine

For testing purposes I installed Version 8 of mySQL Server and here, the collation does not work correct anymore.
When I explicit specify UTF8 within the Connection string, than it works fine.

The interesting Thing is, that when I run:
SHOW VARIABLES LIKE 'collation%';

On Server 5.5 I get:
'collation_connection', 'utf8_general_ci'
'collation_database', 'latin1_german1_ci'
'collation_server', 'latin1_german1_ci'

On Server 8 I get
'collation_connection', 'utf8_general_ci'
'collation_database', 'latin1_german1_ci'
'collation_server', 'utf8mb4'

I can set the collation_server on mySQL 8 to "latin_german1_ci", but the Problem itselfs stays.

Was / is there internal any difference, when Connection to 5.5 or 8?

THX for advise - Harald

Zero-G.

Hey

Sorry for the late reply. It seems your post went straight into my spam…

Is there any chance to rollback DML on error?
Even directly in script?

THX for tips into this situation

Zero-G.

Hey
This is my code, which I use to run a script:

Code: Select all

        
        Private Shared Function ExecuteScript(ByVal script As String) As Boolean
            Dim locReturnValue As Boolean = True

            Using locConnection As Devart.Data.MySql.MySqlConnection = New Devart.Data.MySql.MySqlConnection(mySQL.GetConnectionString)
                locConnection.Open()
                Dim locScript As Devart.Data.MySql.MySqlScript = New Devart.Data.MySql.MySqlScript(script, locConnection)
                AddHandler locScript.Progress, AddressOf OnProgress

                progressStatements = locScript.Statements.Count
                Dim locTransaction As Devart.Data.MySql.MySqlTransaction = locConnection.BeginTransaction()

                Try

                    locScript.Execute()
                    locTransaction.Commit()
                Catch ex As Exception
                    locReturnValue = False
                    locTransaction.Rollback()
                    Start.WriteToErrorLog(ex, LinqProvider.MessageCaption)

                Finally
                    locConnection.Close()
                End Try

                RemoveHandler locScript.Progress, AddressOf OnProgress
            End Using
            Return locReturnValue
        End Function

When an error occurs, then the rollback is not done.
What am I doing wrong?

THX a lot

Zero-G.

Hey

I would ask you to add a very useful feature:
Drag/Drop columns to a new table.

Example:

Click to create a new table.

Within the Treeview of DataBase explorer, where all servers/databases/tables are listed, allow to drag a column.

Allow to drop it into the Columns area of an other table and all specific details of the dragged column get inserted there automaticly

THX a lot in advance

Zero-G.

Hey

Could you please give me advise, what's the best way to change from "offline installation" to nuget.
Which nuget packages do I need to downlad/install? (I use EF6 with mySQL in my software)

THX in advance

Zero-G.

Hey

I use Entity Framework and I my tables are defined with Guid as Id field.
Now, I have in one table a Guid field, which is related to an other table, which can be 0 or one.
When I try to insert an empty field like:

Code: Select all

Table.GuidField = Guid.Empty
' Or
Table.GuidField = Nothing

The field get's a value of '00000000-0000-0000-0000-000000000000'
(Which is specific for Guid.Empty)
The Problem is, that I get an Foreign Key Error, because in the related table, there is no GUID record, which has this value (of Course there is no one)
But, how can I set this field to NULL?

THX

Zero-G.

Hey
Did you get my Project?
Have you been able to reproduce the Problem?

THx

Zero-G.

Hey Mariial
I have sended a sample Project to reproduce the Problem.
Please Reply as soon as possible.
THX

Zero-G.

Hey

I try to get a LinqConnect Project running as Oultook Addin with VB.NET
For Information: The target Database is mySQL

To reproduce:
Open Visual Studio (my case 2015)
Add new Visual Basic Project: Office/SharePoint -> Outlook 2013 and 2016 VSTO Project

Then add a new LinqConnect model and add a few classes from a database first Project.
After that, in the

Sub ThisAddIn_Startup() Handles Me.Startup

Try to create a Context like this:

Code: Select all

Sub ThisAddIn_Startup() Handles Me.Startup
       Using locDataContext As New DataContext
             
       End Using
End Sub

When the Code Comes to End Using (or dispose, I tried both), then the Project crashes (it just Returns to Outlook)

Please help - THX

Zero-G.

THX
That solved the Problem.
But for Information:
The Visual Basic Template for Self-Tracking Entity isn't working correct after adding the EntityFramework.dll for the aspects.
The reason is, that The Property EntityState is getting ambigous. And so all properties have to been set explicit to Data.EntityState.

Have a nice day!

Zero-G.

Hey
THX. - I still tried this. But I can't find the IndexAttribute from within the DataAnotations.Schema Namespace.

https://msdn.microsoft.com/en-us/librar ... .113).aspx
Here a Picture, which possibilities I have to choose from

https://onedrive.live.com/embed?cid=7D6 ... 7puvX9DXCs

Please give me advice, how to do it right. - THX

Zero-G.

Hey
Thanks for your answer.
Here is, my way of work (and probably a Suggestion for an upcoming release)
I started with Code first aproach. But by using your graphical Environment EntityDeveloper.
As you said, within the tool I do have the Option to update the database.
But when I roll my program out to my customers, I don't have this Option. - So I have to update the database by Code.
When I do the Code First Aproach provided by Microsoft, then it works fine, but with the end result, that I can't see the changes within Entity Developer. - So I have to do the changes twice.
1) Within the Entity Framework
2) Writing the Code first changes by Hand.
This isn't a clean way.
As Workaround I could Change the tables within Entity Developer and let me create a script of changes and run this script through my Clients database on update.
But then, the strong typing aproach from Code first isn't given anymore.

Hope you understand what I try to do.
As Suggestion for an upcoming Version it would be good, to have the possibility to automatic generate a Code first Migration peace of Code.

THX

Devart Forums

Search found 399 matches

Integer width deprecated

MySqlDependency with Parameterized Query

MySQLDependency and Entity Framework

Collate Problem when upgrading the server

Re: Script with Transaction does not roll back

Script with Transaction does not roll back

Feature request

Howto change "normal installation" to nuget

How to insert NULL Guid field?

Re: Project Outlook Addin and EDML File crashes

Re: Project Outlook Addin and EDML File crashes

Project Outlook Addin and EDML File crashes

Re: How to set IsUnique within Entity Developer

Re: How to set IsUnique within Entity Developer

Re: Entity Developer migrations