I am using an Entity Data Model (.edmx) in my project. I am using context.Customers to bind the grid.
Now when the datasource is binded to grid, i made some updates for 2 rows in the database.
Now, how can i capture those 2 updated rows in the context........?
I am setting up my new project..We are using entity frame work 4.0..
Is there any way to generate all classes and interfaces as we create manually for 3-tier architecture...
Or do i need to generate manually...
Ex:
Itest.cs
Public Interface ITest
{
int testproperty {get;set:}
}
Test.cs
Public class Test: ITest
{
public int testproperty {get;set:}
}
I have a page that shows the value of a property of my model. The value of that property is changed in the action-method of the controller (that recieves the model as a parameter). It turns out that this line of code:
<%= Html.TextBoxFor(m => m.Problem)%>
does not represent the value that it got in the action-method-code (just the value it got from the POST), but this does:
<input type="text" value="<%= string.IsNullOrEmpty(Model.Problem) ? "" : Html.Encode(Model.Problem) %>" />
Is this a bug or is some caching-mechanism working against me?
BTW, it is especially annoying when using HIDDENs, because the user can never change that value at all... That's how I found out...
I have a demo-project demonstrating the problem here for download. It is based on the default-application, so very small.
I am working on an ASP.NET MVC 2 project with VS 2010 and out of nothing I get the following errors on my views:
The name 'Html' does not exist in the current context
The name 'Model' does not exist in the current context
It is like it is not recongnizing the MVC Html and Model classes.
I have System.Web.Mvc on my references and on Web.Config I have:
[Code]....
I'm curious as to what people consider better practice, between duplicating model structure in the view model and using a mapping tool to move data between the two, or aggregate the model inside the view model, i.e. have a property on the view model class that is a reference to the actual model. Which is considered a better approach in general?
View 1 Repliesgetting 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.
[Code]....
I have an EDM, it includes the entities extension and history. My goal is to use history to keep track of all the changes made to extension entity. For example, if extension with ID 223 has its property 'Name_Display' changed - I want the history entity to record this.
I'm using ASP.NET with VB.NET. Where in my code do I put the hook to say, "update the history entity" and what should that hook look like?
I have a details view control which contains a dropdown list.
I would like to update a row in the DV based on when the selected index change event occurs in another row of the
So far I know that 1) Place code in detailsview1.rowupdating event .
2) Make a row copy, not sure about the syntax here
Dim
aRow As DetailsViewRow =
Me.DetailsView1.Rows(DetailsView1.Rows.Item(?))
3) Find my DDL
Dim aDDL as dropdownlist = CType(aDDL.cells(?).Findcontrol("Dropdownlist3"0, dropdownlist)
If aDLL.selected IndexChanged then
Dim aTextbox as textbox = Ctype(detaislview.cells(?).findcontrol("Textbox6", textbox6)
aTextbox.text = now()
I make use of validation with data annotations in my model classes. How do I make sure this annotations are not violated when I validate data in my business layer, before sending it to the DAL? I guess I don't want to define the validation rules in two places (model classes and in my BLL-classes)?
View 6 RepliesI am using a model but as I want to have clean views I use the viewmodel approach which is like a downsized model which I map in my controller actions before sending to the view or getting it back in a HttpPost attributed action.
My question is: where to put the data annotation attributes. On the viewmodel classes or on the model? If I get it clearly the viewmodel annotations are used for the client side generation of validation right?
Do does that mean I have to put data annotations everywhere on both model and viewmodel?
I am using the ADO.NET Entity Framework for loading data from the database. The classes are directly mapped to database tables in the database. The problem is that these classes are not optimal for binding to the UI elements. As a result of this I have some custom entities which are populated at the service layer and returned. It is these custom entities (classes) to which I bind the UI elements. My questions on this are1. Is populating these entities at the service layer the most appropriate way to do this. I personally do not think so because if we introduce some additional UI elements which need different entities then I have to modify the service layer again.2. What is the best approach/pattern to get this done.
View 2 RepliesI'm working on a project which is using EntityFramework 4 and I am using the entity objects as my business objects. I ran into an issue recently where I had a context declared in a using statement in a user control. The method the statement was in returned an entity object which got used in another control. So I had to detach the entity then attach it to the new context in the other control. I would like to avoid this if possible. What I'm thinking is I would like to declare a context in the master page and then pass that to any page/usercontrol that needs it so they are all using the same context and I don't have to write all these using statements.
My questions are these:
1) is it a bad practice to declare a context on Pre_Init/Page_Load and then dispose of it on Page_Unload?
2) if it is what is the best practice for handling them?
3) if I do go the route of declaring the context in the master page what is the best way to pass that to the pages/usercontrols?
I have been trying to achieve the following:
1-Allow the user to change the quantity in a textbox i.e // "txtQuantity"
2-capture the newly entered quantity i.e //int integerNewQuantity= int.Parse(textNewQuantity.Text);
3-update the database using the newly entered quantity i.e. //UpdateItem(data,integerNewQuantity)
Problem:1-I have not been able to capture the text i.e. the newly entered quantity i.e. the value entered in the text box "txtQuantity"
2-Hence the database is updated using the existing value and NOT the new value unless I make a constant assignment as below:
textNewQuantity.Text = "2"; When tested the assignment of any number correctly updates the database. see the c# code:
C# code: Version.1
protected void btnUpdate_Click(object sender, EventArgs e)
{
txtItemDescription.Text = txtItemDescription.Text + "from btnUpdate talking.."; [code]....
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 :
First Name:--- instead of : fName:---
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 have a gridview bind to an object datasource Now there is an edit button to edit the entriesUser selects new entries and clicks update Gridview gets updated (all previous entries replaced)Now the new records dont contain the table id of the previously added rowsOn form update, how do I know which entries to drop from database and which entries to insert as the previous rows are all gone?the results are in form of collections of objects returned by object datasource.
View 6 RepliesI need to know how to check last updated rows in Gridview.
View 2 RepliesI 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?)
In my GlobalMasterPage I use a custom control which displays a logo and a Title:
<%@ Register Src="UserControls/Header.ascx" TagName="Header" TagPrefix="uct"%>
<body>
<div id="header">
<uct:Header id="Header1" runat="server"
TitleOfApplication = "Logging Viewer v1.0"
TitleOfTeam = "Team One" />
</div>
</body>
</html>
Now, on the pages that use that GlobalMaster page I have a button on each one which allows you to jump from one page to another,
basically I do a Response.Redirect.
What I am trying to do is to find a way to change the Title of the application according to the button that the user clicked. I was trying to get the current handler but that does not work well for me:
[Code]....
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.
how can I add context menu in gridview rows
View 2 Repliesi have a database with 4 table aspnet_Users, Forum, Topic, Post thay are related:
aspnet_Users with Topic by UserId
Forum with Topic by ForumId
Topic with Post by TopicId
i created a linq to get data from Database like:
[Code]....
now i need to get also how meny post are in a topic but i don't know how to write the querry.
when i create ado.net entity data model and I add two tables only one is added to entity data model
none of the tables have any kind of relationship are simple tables.
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