12/6/2011 11:04:48 AM
Topic:
Crqsh on SQL Trigger
Jurgen Stillaert
Posts: 2
|
Hi,
I've found the solution. When you change the executionplan property to none it works, but you don't have an exection plan link of course. But that is acceptable.
Regards,
Jurgen
|
|
|
12/6/2011 1:22:33 AM
Topic:
Crqsh on SQL Trigger
Kristofer Andersson
Posts: 331
|
Hi Jurgen,
Do you have an example of one of the tables involved and the triggers on it? That will make it easier to reproduce in-house for tracking down the cause of the problem...
Best regards,
Kristofer
|
|
|
12/2/2011 7:47:42 PM
Topic:
Crqsh on SQL Trigger
Jurgen Stillaert
Posts: 2
|
Hello,
Just bought a license key and now run into a major problem.
I have set up my web application to monitor all Linq to Entities database calls in DEBUG mode.
I was now implementing Caching with a SQLCacheDependency. This needs to implement triggers in de SQL database. But everytime an updates happens on the table from the application, it gives the following crash:
The member with identity 'Microsoft SQL Server 2005 XML Showplan' does not exist in the metadata collection.
Parameter name: identity
I have been looking to several options, and finally found out that the problem lies in the Huagati dll. When turning of monitoring, it works like a charm.
Can you help me with this problem? Is there a work around?
|
|
|
8/26/2011 1:16:27 AM
Topic:
Button names in Model Comparer cut off
Kristofer Andersson
Posts: 331
|
Hi,
Thanks for reporting this issue.
Yes, a few users have reported DPI scaling issues recently. I will try to get that fixed in the next update.
Best regards,
Kristofer
|
|
|
8/24/2011 3:04:59 PM
Topic:
Button names in Model Comparer cut off
StuartDLeitch
Posts: 1
|
I'm getting a weird issue where the buttons to "Update SSDL", "Update Database" etc. in the Model Comparer are being truncated. Please see attached file. It makes it very hard to use as it is easy to accidentally click the wrong button. Has anybody seen this issue before?
Cheers,
Stuart
|
|
|
6/3/2011 9:42:07 AM
Topic:
Introduction into Model Comparer
Kristofer Andersson
Posts: 331
|
Hi Thomy,
The buttons under each tree (database/ssdl/csdl) are used for applying diffs selected in that particular treeview to another layer, or to itself.
The "Update SSDL" button under each tree is used for updating the SSDL layer with differences selected in the layer that the treeview correspond to.
In other words, if the Model Comparer shows a set of new/changed columns in the database tree and you select one or more of those and click on "Update SSDL" under the database tree, the SSDL will be updated to correspond with the database for the selected objects. Likewise, if you select some difference in the CSDL tree and click "Update SSDL", the SSDL will be updated to correspond to the CSDL for the selected objects. Finally, if you select diffs in the SSDL tree and click "Update SSDL" then the SSDL will be changed to match the layer if differs from.
There are a couple of screencasts/videos showing it in action here:
http://huagati.blogspot.com/2010/07/introducing-model-comparer-for-entity.html (15 min)
http://huagati.blogspot.com/2010/08/using-model-comparer-to-generate.html (15 min)
http://huagati.blogspot.com/2011/05/entity-framework-model-creation-beyond.html (4½ min)
Best regards,
Kristofer
|
|
|
6/3/2011 9:26:34 AM
Topic:
Introduction into Model Comparer
Thomy Mutter
Posts: 1
|
Hi Folks
I'm pretty new to Huagaty DBMX-Tools but I hoped to find here a tool to selectively update my EF model with changes in the underlying database model. Now I'm a bit lost with the usage of the model comparer.
Is there somewhere an introduction how to use this tool? What is the difference between "Update SSDL" under Database, Storage Model and Conceptual Model? How do I add a new column in a database table in the EF-Model using the model comparer? What happens pressing the different buttons on the dialog?
Thomy
|
|
|
5/28/2011 11:40:40 AM
Topic:
Foreign Key Constrains Not Matched Correctly
Saud Almutairi
Posts: 1
|
on the "Differences" Dialog under the folder "Foreign Key Constraints" for both "Database" and "SSDL", it shows the same constraints but on the Database side the name starts with "FK_" this is what the model generated sql script creates.
so every time i create a new association i have to click on "Ignore", is there a way to customize the tool to pick up the "StartsWith" -> "FK_" naming for "Foreign Key Constrains" .
thanks for the great tool.
edited by Saud Almutairi on 5/28/2011
|
|
|
5/25/2011 10:43:49 AM
Topic:
Model Comparer DisaAbled
moneill
Posts: 22
|
I have 2 keys as you say , I thought I had the newer one applied , I have applied the one from the XML file PRO_DBML-e90xx-xxxx and restarted VS 2010
Looks like I had the old one in place , not too sure how ... as I have used the Model Comparison tools regularly with no changes to my set up
All is now well, I'll know where to look if I have any other issues.
Thanks Mike
|
|
|
5/25/2011 5:06:04 AM
Topic:
Errors when comparing stored procs.
Kristofer Andersson
Posts: 331
|
Hi,
It is probably not a permissions error, it looks more like a failed lookup in the dbml file.
Would it be possible to share the signature of the stored procedure (e.g. create procedure xxx.xxx ... ) and/or the dbml file that you get this error for? You can send it to support@huagati.com .
Best regards,
Kristofer
|
|
|
5/24/2011 9:27:53 PM
Topic:
Errors when comparing stored procs.
dflipp
Posts: 1
|
I'm getting this error when using the "Update Linq-To-Sql diagram from database" command.
An error occured when checking the procedure/function <name> for changes.
HasChanged failed for stored procedure or function <name>. Missing modelProcDefinition
Is this a permission issue on the db server?
Thanks,
Dan
|
|
|
5/24/2011 11:17:26 AM
Topic:
Model Comparer DisaAbled
Kristofer Andersson
Posts: 331
|
Hi Mike,
Make sure you are using the correct license key. You have two keys (original one from 2009, and an upgrade from 2010 that adds the model comparer etc). The latest one should enable the model comparer etc.
Best regards,
Kristofer
|
|
|
5/24/2011 9:32:23 AM
Topic:
Model Comparer DisaAbled
moneill
Posts: 22
|
Hi
I open up the edmx file in the normal table view format , I see the DBML/EDMX Menu , but both Model Compare and Extract Complex Types is disabled
How shoudl I activate the Model Compare ?
I have a few add ins in play such as Resharper could they me affecting ?
Is this right ?
V 2.2.24
Cheers
Mike
|
|
|
5/17/2011 12:04:20 PM
Topic:
Error: Updating entity/member names failed
Kristofer Andersson
Posts: 331
|
This was caused by a mismatch in complex type references after mass-renaming.
A bugfix for this issue is included in version 2.24 (released today). Please download the latest version and try again.
Best regards,
Kristofer
|
|
|
5/17/2011 12:03:06 PM
Topic:
Error when updating diagram from database
Kristofer Andersson
Posts: 331
|
Hi,
Sorry for the delay. An update containing several bug fixes (including this issue) was released today. Please download the latest version and try again.
Best regards,
Kristofer
|
|
|
5/17/2011 12:13:49 AM
Topic:
Error: Updating entity/member names failed
msigman
Posts: 6
|
I would also point out that we are not in EF4 but rather LINQ to SQL.
Project type is C# Web Application.
|
|
|
5/17/2011 12:13:10 AM
Topic:
Error when updating diagram from database
msigman
Posts: 6
|
Hello,
Any idea when the fix will be available? It's been two months since I reported this issue...
Thanks!
|
|
|
4/28/2011 4:20:25 PM
Topic:
Error: Updating entity/member names failed
Zoe
Posts: 2
|
As noted in separate email, my EDMX is contained in a Visual Studio 2010 C# Class Library project. That project is then referenced by a separate Visual Studio 2010 C# Web Application project.
|
|
|
4/28/2011 2:35:51 AM
Topic:
Error when updating diagram from database
Kristofer Andersson
Posts: 331
|
This looks like a bug related to the "schema less mode" feature. A fix for that issue is coming in ver 2.24.
Best regards,
Kristofer
|
|
|
4/28/2011 2:28:58 AM
Topic:
Error: Updating entity/member names failed
Kristofer Andersson
Posts: 331
|
Hi Zoe & msigman,
msigman: Sorry, I must have missed that.
Both: What type of VS project ( C#/VB, web app / website / winforms exe / ..?).
Would it be possible to share the EDMX file involved with me to attempt to reproduce the issue in-house?
Best regards,
Kristofer
|
|
|