Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I've created an Application Model in SP Designer 2010 and exported it (XML file). I'd like to use the definition in a Business Data Connectivity Project in Visual Studio 2010.

Is there a way to create a project and import the model? It seems like an easy way to create the model then be able to package the model in a solution and deploy with the new VS 2010 F5 functionality.

An added note to this problem is that the data is accessible through stored procs so the BCS Meta Man in it's Alpha build won't help us out.

share|improve this question
add comment

1 Answer 1

you can copy and paste the XML model from SharePoint Designer into the VS model file if you open it in an XML editor. It will be exactly the same as the SPD one though so you'd need to make quite a few changes to call code methods instead of SQL queries.

If you try out BCS Meta Man:

BCS Meta Man

You can open a model created in SharePoint Designer and it will generate the c# methods and model required for you. Here's a blog post that shows it in action:

Upgrade SPD models into .Net Assembly Connector

Hope this helps Nick

share|improve this answer
    
Nick, the BCS Meta Man tool is great but at present doesn't play well with stored procs. We only use stored procedures as it adds additional security and optional coding flexibility. –  Anonymous Jun 4 '10 at 13:23
    
Hi Scott, thanks for the feedback, we'll bump stored procs up our development schedule. If you have any other feedback about the tool please feel free to post it in the forums or shoot me an email connect.lightningtools.com/… –  Nick Swan Jun 7 '10 at 8:49
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.