I’ve created some time ago a local MDF file with a bunch of tables for use. So now I want to get back to it and implement it through the edmx Ado.Net template
After I’ve added the mdf local db file to the App_DATA folder I can now connect it to the automatic created scheme like this –
I will go through the wizard and choose the objects of tables to recreate at the edmx model
At the end I will have the objects created with C# from DB for me by this automatic process.
Rebuild your solution to make everything checked and ready to go!
I am adding a controller
By description I want the scaffold to build everything for me – including the view representation of my objects.
Choosing the entity to render
After a lot of thinking on his part I am getting new files in the solution folders structure
At the present project I’ve encountered a problem of working with Oracle through the portal of SqlServer .
q: What is the need for it ?
a: Reduction of development time ..
So , I have at my project a few tasks :
- Create a DB schema and fill it out with temporary data.
- Create quickly a code corresponding with database
- Add sources of Oracle to SQL SEVRER .
- Include handle of UDT objects .
- use it – The download link for SSMA for Oracle.
- Be able to work with web services , maybe RIA services , especially with Oracle UDT objects . This is a sample of Grid Silverlight through RIA Services .
If I’d start doing all this things through the procedures of Oracle I would need at least one DB programmer working on it for about a month and a half I think , and then I’d need a .Net programmer that would work on his end for the same amount of time , probably not in parallel , so it would prolong the development in 2 , maybe even more.
The goal is to create a DB in SqlServer and create corresponding entities automatically .
Then create RIA services per entity . (Well RIA Services is really a luxury , so we’ll see how it goes ) .