EDIT: This question is vague and will likely be of little use to anyone. I am awarding internet monies to the gentleman below whom "helped" me.Sorry that the title is a little vague. I am still new to asp mvc & EF. Here is my issue. I have a DB somewhat like this.
Employee
- ID
- Name
- Address
EmployeeJob
- EmployeeID
- JobID
- StartDate
JobTypes
- ID
- JobName
I want a create form that will show all the Employee fields as well as a list of JobTypes for the users to be able to select. Then I will post the results back to the controller and update the DB. I have started looking into custom viewmodels, but am still unsure of exactly how to put that together and get it to work.
I'm trying to customize correct displaying of dropdownlists so information shown in comboboxes is relevant to the kind of user logged on (maintaining referential integrity at data level)
e.g.: I have a user already logged on and depending on his profile I'd like to display to this user only the portion of the database that he would be allowed to see. That would mean that he might have acces to an specific subset of data, e.g.: businesstype = "3", loging level = "2", etc.
Is there a way of creating an Ado.Net Entity Data Model filtered on a Session variables as to maintain proper referential integrity at data level?
When adding a stored procedure into the Entity Data Model I can select whether the procedure returns a scalar, a (new) complex type or one of the entity types I already defined.I mean assuming I have a view like this
CREATE VIEW FilteredFoos as SELECT Foo.* FROM Foo join ... WHERE ...(that is a view that implements some involved filtering, but returns all columns from one table) how do I add it to the project so that I can use the entity set, but get the Foo objects, not some new FilteredFoo objects.
var foos = myDB.FilteredFoos.Include("Bar").ToList(); foreach (Foo foo in foos) { ...
getting data from multiple Entities models into an MVC controller. Most of the examples I have seen for using EF in an MVC2 app only use a single entitiy.
I have just started using MVC2 in C# using the Entity Framework models (CIOps.model) created from an SQL database. I can create the controller and views using single tables of the model in MVC2, but I just cannot get my head around how to get data from multiple entity tables into the controller (similar to joins in T-SQL). I have included an example below of the controller code that works with a single entity table, tbl_tours (tbl_tour in DB).
Could someone please illustrate how this code would be changed to include additional columns from FK tables in addition to tbl_tours columns. E.g. the clients name from the tbl_clients, the coordinators name from the tbl_employees, and costs from tbl_costs entities? Is it possible to do this directly using the EF model entities/classes that are already created and not use LINQ, POCO, Repositories, etc.? The FK relationships are already in the EF models. I have included the whole controller code, but I just need a few examples of how to join the multiple entities, not rewrite every CRUD function function in the controller. I think this will get me over the hump in using EF in an MVC2 App. Also ignore the fact I am using the home controller, this will change in the application.
I made a few changes to the DB in SQL server management studio then right clicked on the .edmx doc to get it to update. That seemed to work fine but when i compiled the app everything that referenced the EF seems to be broken.The Error list now contains the below error for all classes that used it.
The type or namespace name '' could not be found (are you missing a using directive or an assembly reference?)
I am a newbie in mvc3 and i'm wondering how to use attribute like [Display(Name="")] for model that comes from an entity data model that I provide im my "Model" folder in my mvc3 project.
I didn't provide a .cs class for each of my database tables .
other words, I want the controller class render a edit form for me like :
Is there a way to export a EF 4.0 Data Model to EF 3.5?
I looked around and found that we are not able to access EF 4.0 from a ASP.Net 3.5 project here: [URL]
Our project is the 1st to go to .Net 4.0 using Entity Framework and we (the team) were wondering if there was a way for the other projects that "might" need to access our data that are still using the .Net 3.5 framework.
I've been used to decorating data model classes with data annotation attributes, but the purist in me baulks slightly at including purely presentational attributes such as display format here. I am, however, quite happy to keep validation centric attributes here. One good reason I have to continue keeping all annotations etc. in the data model is that my view model aggregates data model classes, e.g.
my ViewModelBase.DetailItem<TEntity> property in the view model is just a reference to an entity class in my data model. If I wanted to move presentational annotations to the view model, I would have to quite radically revise my design to one where I duplicate data model properties in my view model and use an object mapping tool to populate view model objects based on data model objects.
Say I got a domain model as follows: (and my repository expect an instance of this object)
[Code]....
And a view model (which my views are based on)
[Code]....
At the moment I got it like this and have my controller action manually create a new Person object from the PersonModel object before passing it on to the repository, which does not feel right.
So I tried to have PersonModel inherit from Person and pass that to the repository (also tried casting the PersonModel to a Person object first), but that don't work out.
What's the right way to have PersonModel automatically cast to Person? I want to keep this logic as my current structure allow me to keep things really loosely coupled, with the repository layer not having a clue how it's being used.
I program in ASP.NET for a while now. My applications uses always the DataSet. Some told me that Entity Data Model is the DataSet for LINQ. Now I want to try to working with it I have some questions but can't find the answers. I hope someone can. When I build an application I use the 3-tier structure. So Presentation-layer, Business-layer and the Data-layer. Normally I had some classes in the Data layer with specific methods to interact with the DataSet. When I read the table or something I create an object for the business layer.
With the Entity Data Model it seems a little bit confusing. If I read a table (for example Company) the edmx has created an class already. So is the edmx a replacement for the Data-layer and also for the Business layer? Is the edmx also a good use for multi-user application or is a connected application better?
For VS 2010, I am trying to add new item of existing mdf file. By : Add new item -> Data -> ADO.NET Entity Data Model -> Generate from database.
When I reach the step of "Choose Your Data Connection", under the : "Which data connection should your application use to connect to database?" The combo-box is empty. How can I make that combo-box not be empty (some configurations?)
I want to build my Model around Entity SQL. I'm pretty comfortable with writing SQL queries hence my choice for using entity SQL.
In my model i have this:
namespace Model { public class Person { public string Name { get; set; } public string SecondName { get; set; } public int Age { get; set; } public DateTime DOB { get; set; } public void Save() { //to do } public List<Keyword> GetKeywords() { //get data from entity DBEntities context = new DBEntities(); string sql = "SELECT * from Keyword"; EntityCommand cmd = new EntityCommand(sql); return ; } } }
how do I execute entity SQL comment?
how can i return a list that is returned from this query?
if i have different classes that need access to DB would I always have to specify "DBEntities context = new DBEntities();" or is there a better way so that all my classes have this configured?
I'm trying to update values I have stored in an IEnumerable using UpdateModel, but it isn't reflecting the changes when I step over it in Debug.I also tried upating it using a foreach loop and updating the values in each object T within the IEnumerable<T>. The values are changed at the object level, but it seems that the value of the object in the IEnumerable isn't being changed.I was looking at IEnumerable<T> and didn't see a way to update it... I'm thinking that I might have to assign the updates to some other data structure, then convert it to an IEnumerable or something before I try to save my repository
I have some questions in my mind after went through the video tutorials.
Is Model a entity class type? encapulated attribute and methods (business logic). because i see in videos , people use LINQ to generate models which can only use LINQ to modify/insert/delete data.
Is it a good practice to generate Model using LINQ?
There are some tutorials explaining how to create a Model based on Linq to Sql or The Ms Entity Framework. Can I use my custom code for a model? If we have the controller with the code :
[Code]....
This returns a List<Movie> to the view that knows what to do with it. Is it possible that I create a method called MovieSet that returns a List<Movie> using a sql qry or a stored procedure call without the creation of an Object for this purpose ? Or do I need a Movie object? Lets say that I just to do my query, loading data into a dataTable and load that data to a list of movie objects. Because the code created by the Entity Framerwork is too big for a quick reading.
I want to use entity framework model for visual studio 2010. I am using oracle database. i was wondering if it is possible to use entity framework for oracle. If it is not possible then I will just use simple ADO.net and call stord proc and packages. I already downloaded oracle data provider for entity frameowrk from codeplex web site. I could not see oracle database option when connecting to oracle databse in LINQ to sql. can someone give me any example that connects to a sample oracle database and use LINQ to oracle
I have an entity object as model input in my view. Not sure if it's the best approach, but I use the object references to get values from a related object.Let's say I've got a car entity and a manufacturer entity.Here's how it would look in my view
[Code]....
I've get a nullreferenceexception where the car entitity does not have a reference towards manufacturer. I'd like to output a " " if no manufacturer exists.
've created a Search partial view and it works, except for my view model. What i mean is, the partial view sends a string to my ActionResult Method, but only a string, that is not related to the view model that the partial view is built in. If i tell my ActionResult method to receive the view model in which the partial view is built in, it always tells me that i have null values. Here's my code This is my partial view:
[Code]....
Now here is my Model in my MoviesSearch view model:
one thing that has been puzzling me since learning MVC2 is the following case scenario: I have a view which contains two latest news lists, a login form and a signup form. Every example I found on Views and View Models so far has a one-to-one example such as a simple login form etc. But how do I create a model that provides the properties and validation for a login and signup form and manages the data for the news lists. can I pass multiple models in the strongly typed view? When I created one model the form validation would fail as it expects all fields - login and signup to be filled. I am missing some advanced examples or information.
when I'm building a menu in a view I get following error when code reaches <% Next item%> :
System.InvalidOperationException was unhandled by user code
Message=The value of a property that is part of an object's key does not match the corresponding property value stored in the ObjectContext. This can occur if properties that are part of the key return inconsistent or incorrect values or if DetectChanges is not called after changes are made to a property that is part of the key.
Source=System.Data.Entity
My view: (its a userview)
[Code]....
My Model [Code]....
My Datasource [Code]....
I use this way of looping frequent the only thing is that this is that this entity has a view as source and not a table, so I think it has to be related with that.
I have followed this tutorial [URL] to get a google map displayed but now I want do the next step and read the long/lat and text out of my ADO.NET Entity Data Model and put it on the map (preferably the text should appear when clicking on the red spot in a white text box - as you know it from google). Has someone done this already and could let me know how I get the points on the google map? THis is how the function in my controller looks right now:
Function Map() As ActionResult ViewData.Model = (From m In _db.ahn_mappoints Select m.LONG, m.LAT, BLOG = m.Text.Substring(0, 81) & "...").Take(2).ToList() Return View() End Function
