MySQL Bugs: #64385: EDM TYPE NOT SUPPORTED WHEN ADDING AN IMPORTED FUNCTION FROM PROCEDURE

Bug #64385	EDM TYPE NOT SUPPORTED WHEN ADDING AN IMPORTED FUNCTION FROM PROCEDURE
Submitted:	20 Feb 2012 18:35	Modified:	25 Dec 2013 17:26
Reporter:	Gabriela Martinez Sanchez	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Visual Studio Integration	Severity:	S2 (Serious)
Version:	6.3.8	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	Connector/Net, entity framework, procedures

Description:
After trying to add an existing stored procedure to an existing Database
model using EF and Connector/Net 6.3.8 the Get Column information button
lists the columns returned by the stored procedure as EDM type Column not
supported for a simple varchar column or any.

How to repeat:
From a mysql console using 5.5 server:

Create stored procedure:

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp1`()
begin
select name from myauthors;
end

On visual studio
- Add stored procedure to an existing or new database model
- Right clic on stored procedure and clic on Add Function Import
- On the dialog clic on Get Column Information
- The name column appears like Edm Type Not supported.

No possible way to retrieve the result from the SP on the Model.

-

Suggested fix:
Update the metadata information from the stored procedure in order to create
the proper list of columns.

There's a workaround for this bug since the mapping of the procedure is done correctly, the only problem is that the constructor of the columns doesn't have a type visible to associate with each column instead it says Not Supported. An alternative for this is to do the mapping of the results of the procedure to an existing entity type. The entity that you want to use should have the same columns as your select on the store procedure, instead of using the complex type option.

I'm sure that this has worked in the past, just can't remember the db/connector versions.  Are you aware of a versionof either connector or db (or both) for which this works.

hi Gregor,

I don't know if there is a version where this had worked. I personally checked this functionality with the mentioned version and it doesn't work and the only way this works is with the mentioned workaround. If you know which version or have an idea about when this was working and you can share that information we would really appreciate it.

Thanks.

Any movement or suggested work around on this?

I'm getting the issue with:
  VS 2012/.net 4.5
  EF 5
  MySQL .Net connector 6.7.4.0

Thanks for any help!

Hi Jonathan,

Have you installed the MySql for Visual Studio 1.0.2 besides Connector/Net 6.7.4?  This is a change in the product so the Visual Studio integration now is part of MySql for Visual Studio. Connector/net only has the library.

Thanks in advance for your feedback.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

On going issue with EDM TYPE

Attachment: Complextype EDMType Issue.PNG (image/png, text), 84.23 KiB.

This is an on going issue!

Microsoft Visual Studio Community 2015
Version 14.0.25431.01 Update 3
Microsoft .NET Framework
Version 4.6.01586

Installed Version: Community

Microsoft Visual Studio Tools for Applications 2015   00322-20000-00000-AA668
Microsoft Visual Studio Tools for Applications 2015

Visual Basic 2015   00322-20000-00000-AA668
Microsoft Visual Basic 2015

Visual C# 2015   00322-20000-00000-AA668
Microsoft Visual C# 2015

Visual C++ 2015   00322-20000-00000-AA668
Microsoft Visual C++ 2015

Visual F# 2015   00322-20000-00000-AA668
Microsoft Visual F# 2015

Windows Phone SDK 8.0 - ENU   00322-20000-00000-AA668
Windows Phone SDK 8.0 - ENU

Application Insights Tools for Visual Studio Package   7.18.00214.2
Application Insights Tools for Visual Studio

ASP.NET and Web Tools 2015.1 (Beta8)   14.1.11107.0
ASP.NET and Web Tools 2015.1 (Beta8)

ASP.NET Web Frameworks and Tools 2012.2   4.1.41102.0
For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563

ASP.NET Web Frameworks and Tools 2013   5.2.40314.0
For additional information, visit http://www.asp.net/

Clang with Microsoft CodeGen   14.0.25516
Clang with Microsoft CodeGen

Command Bus, Event Stream and Async Manager   Merq
Provides ICommandBus, IEventStream and IAsyncManager MEF services for loosely coupled Visual Studio extension components communication and integration.

Common Azure Tools   1.8
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

GitHub.VisualStudio   2.2.0.10
A Visual Studio Extension that brings the GitHub Flow into Visual Studio.

JavaScript Language Service   2.0
JavaScript Language Service

JavaScript Project System   2.0
JavaScript Project System

KofePackagePackage Extension   1.0
KofePackagePackage Visual Studio Extension Detailed Info

Microsoft Azure Mobile Services Tools   1.4
Microsoft Azure Mobile Services Tools

Microsoft MI-Based Debugger   1.0
Provides support for connecting Visual Studio to MI compatible debuggers

MySQL for Visual Studio   1.2.6
Data design and management tools for MySQL.  Copyright © 2007-2015 Oracle, Inc.

NuGet Package Manager   3.4.4
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

PreEmptive Analytics Visualizer   1.2
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

Python Tools for Visual Studio   2.2.50113.00
Python Tools for Visual Studio provides IntelliSense, projects, templates, Interactive windows, and other support for Python developers.

Python Tools for Visual Studio - Django Integration   2.2.50113.00
Provides templates and integration for the Django web framework.

Python Tools for Visual Studio - Profiling Support   2.2.50113.00
Profiling support for Python projects.

SQL Server Data Tools   14.0.60519.0
Microsoft SQL Server Data Tools

TypeScript   1.8.36.0
TypeScript tools for Visual Studio

Visual C++ for Cross Platform Mobile Development (Android)   14.0.25401.00
Visual C++ for Cross Platform Mobile Development (Android)

Visual C++ for Cross Platform Mobile Development (iOS)   14.0.25401.00
Visual C++ for Cross Platform Mobile Development (iOS)

Visual Studio Tools for Apache Cordova   Update 10
Visual Studio Tools for Apache Cordova

Visual Studio Tools for Universal Windows Apps   14.0.25527.01
The Visual Studio Tools for Universal Windows apps allow you to build a single universal app experience that can reach every device running Windows 10: phone, tablet, PC, and more. It includes the Microsoft Windows 10 Software Development Kit.

Xamarin   4.2.1.62 (680125b)
Visual Studio extension to enable development for Xamarin.iOS and Xamarin.Android.

Xamarin.Android   7.0.2.37 (ce955cc)
Visual Studio extension to enable development for Xamarin.Android.

Xamarin.iOS   10.2.1.5 (44931ae)
Visual Studio extension to enable development for Xamarin.iOS.