Tips and Tricks in a world of Mix

Posts tagged ‘ef’

Asp.Net MVC5 build a website DB mdf(local) first

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

untitled-picture1

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 –

untitled-picture2I 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.

untitled-picture3

Rebuild your solution to make everything checked and ready to go!

I am adding a controller

untitled-picture4

By description I want the scaffold to build everything for me – including the view representation of my objects.

untitled-picture5

Choosing the entity to render

untitled-picture6

After a lot of thinking on his part I am getting new files in the solution folders structure

untitled-picture7

That’s it.

Modell .edmx 
Modell Context.tt 
Modell .Context.cs 
Modell Designer.cs 
Modell .edmx.diagram 
Modell .tt 
A dress.cs 
Event.cs 
Events EventDetaiIs.cs 
EventType.cs 
LocationDetaiI.cs 
Modell 
Place.cs 
PlaceForm.cs 
PlaceScope.cs 
SocialNetwork.cs 
sysdiagram.cs 
User.cs 
UserFriend.cs 
Users UserDetaiIs.cs 
Users_UserSecurity.cs 
WorkDetaiI.cs

This slideshow requires JavaScript.

Advertisements

Working with Oracle from SqlServer 20008 with Services–the Architecture part 1

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 :

  1. Create a DB schema and fill it out with temporary data.
  2. Create quickly a code corresponding with database
  3.  Add sources of Oracle to SQL SEVRER .
  4. Include handle of UDT objects .
  5. use it – The download link for SSMA for Oracle.  
  6. 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 ) .

(more…)

Tag Cloud

%d bloggers like this: