I have POCO's in a separate project and now I need Self Tracking Entities. Does anyone know if I need to generate new POCO's that are self tracking and they will replace my current POCO's? Or, do I setup self tracking entities in addition to my current POCO's?
View 1 RepliesWe are starting a new web based product in which we are planning to expose our business logic through WCF services. We will be using ASP.NET 4.0, C#, EF 4.0. In future we want to build iphone applications and WPF applications based on the services. I have been reading a lot about using POCO vs Self Tracking Entities (STE) and from my understand the STEs do not work well with the web scenario.
View 3 RepliesI have a Consumer class and a BillableConsumer : Consumer class. When trying to do any operation on my "Consumers" set, I get the error message "Object mapping could not be found for Type with identity Models.BillableConsumer.
From the CSDL:
[code]....
Is this because I did not specifically add the BillableConsumer entity to the object set? How do I do that in a POCO scenario?
let us assume that I have a reusable business layer that further makes use of a data access layer that was implemented using Entity Framework 4.0. The entities returned/consumed by the business layer are self-tracking, allowing us all the goodies that come with those type of entities. I would like to be able to store the entities I work with across post backs (on order to avoid re-querying every time). Basically let us assume I have a paged GridView with 10 items in it, and something like a DetailsView to edit those items. Every time you select a new row on the grid, the details view updates with the information of the selected row. My preference would be to only query for the entities on the initial request of the page and store it in session. Then subsequently I have a list of entities that I can work with and eventually modify and send back to the business layer with all of the changes.
I really want to use session instead of view state to reduce the page payload (self tracking entities are heavy) however I really like view state for this because of the fact that when the user navigates away from the page there is no residual effect. Some of the things that worry me are: When a user navigates away from the page to another page, the entities from the previous page are still in session. I could always do something on load of a page to do housekeeping type of work. Not sure if that's good practice. I am worried about people opening browser tabs and having two views into the same page, it seems like that might pose a problem. Is this even a good approach? Seems like I am trying to have the best of all worlds, it would definitely be much easier to simply re-query on every post back for the entities and pay the 50-100ms hit of the database trip.
I have a model that consists of Order, OrderLine, Product.
I want to create an Order and add OrderLines (each OrderLine related to a Product). I create the Order and add new OrderLines to it. Between posts I store the Order entity in Session (or ViewState). Just so you know I have added suppport for binary serialisation which works fine.
The relationship is therefore Order > OrderLine(s) > Product(s).
You might have already guessed what the problem is - that when I SaveChanges() I get the usual 'AcceptChanges cannot continue because the object's key values conflict with another object in the ObjectStateManager.' error.
I have referred to a number of articles online but none seem to handle this case (where I have the relationship across more than two entities) e.g. [URL].
This must be a very common requirement surely? Is there anyone out there doing the same kind of thing with Entity Framework (and without using DTOs etc)?
I have looked at two of Microsoft's tutorials for MVC. In one tutorial they are creating a .edmx file to handle the Entity Framework in order to execute Linq queries. In another tutorial they made a class called "MusicStoreEntities.cs" here is the code:
using System.Data.Entity;
namespace MvcMusicStore.Models
{
public class MusicStoreEntities : DbContext
{
public DbSet<Album> Albums { get; set; }
public DbSet<Genre> Genres { get; set; }
public DbSet<Artist> Artists { get; set; }
public DbSet<Cart> Carts { get; set; }
public DbSet<Order> Orders { get; set; }
public DbSet<OrderDetail> OrderDetails { get; set; }
}
}
And the tutorial creates an instance of this class and starts doing Linq queries as well. What are the differences between these 2 methods? and how can I make DbSet objects in a .edmx file?
I have a datamodel with a couple of tables. One of my tables have about 40 fields (I know that is a lot, but we have to keep the structure in place as we are upgrading a classic ASP project to MVC). Some of my Actions only updates 1 or 2 fields in my table.
Is there a way to create Entities, for instance, that only contains the contact details of the client table, and not any other details, and then another entity that contains only the address details. I don't want to submit the entire row when I only update telephone details, or the client's picture.
I am using EF4 with POCO entities and having problems to update an existing item. In a webbapp I have an ajax function fetching an entity object from the database through EF4. Then i make some changes to it and when I try to update the record in the database I call the Attach-method but it is not saved. I guess this has something do with that I am not in the same context anymore...so my question is how to make an update of a previously fetched record if the context which was used to fetch record is disposed?
View 3 RepliesI need to know is there any way to separate the classes automatically created by Entity framework. I can not use POCO template. because I have restriction to use framework 4.0 for time being.
I am having VS 2008 Framework 3.5
Do I have any service packs which gives me POCO.
In EF4, is it possible to convert a POCO object (created using new MyObject()) to a Dynamic Proxy (like you would get with ObjectContext.CreateObject())?
Using EF4 with T4 template for POCO.
So I used this tutorial to generate my poco classes which I am to use throughout my aplication.. the problem is that Im not supposed to modify the generated cs files cause they get autoregenerated... How do I add attributes like [Required] and stuff like that??
View 2 RepliesAnyone know of a simple tool to quickly create POCO classes based on an existing database?
I am just looking to create the POCO classes that could be used with any ORM that supports it so my interface and model can remain independent.
I have an interesting problem with a WCF Service I am creating. As background fodder my solultion uses MVC 3 RC2 as the web interface. I am developing the solution as an N-Tier application using the Entity Framework 4.0 with POCO Self Tracking Entities, repository and unit of work approach. I am using the STE's more as an advanced POCO since STE do not seem to play well as of yet in the real world as they were meant to and since they do seem to give me better interfacing with the DB through my layers still. Additionally, I am incorporating WCF into the solution as the backend for the models based on info I am reading and the fact that I will need to also access these services via a windows service app on the client computers.
So, I have a datastore which includes my edm and the repositories. The POCO STEs are generated in a separate layer in what I have called my Domain Models. Within my domain area I also have a Core app holding my utilities. I am currently incorporating an additional domain element as a WCF service using the RESTful template. This WCF will be servicing both my MVC controllers and a Windows Service app on the client computers.
Now, on to the problem: Within this solution I have an Entity Set of People (or Person?). Within that Entity set I have a chain of inherited entities as follows Person->User->StaffMember->Provider where Provider is the resultant child. Within my WCF I have a ProviderService, a StaffMemberService and a UserService. In each of these Services one of my OperationContracts is a Get(string id) amongst others. the Get(String id) contract is the one that is causing me problems. Within that Get(String id) contract I do the following for the User:
[Code]....
and for the Provider:
[Code]....
Now, what has gotten me completely confused is that the Provider one works like a charm. But if I use the UserService to call the User of the same Id (Since User is a base class for Provider, this should work) I get an error saying it was a bad service call. (The ProviderService, as stated works and returns all the correct data). When I debug it, the UserService Get(String id) function actually works as expected up to and through the return statement (ie the user variable actually contains all the proper data that I would expect on the call). It is only after the return that I get the web page giving me that error and points me to the help page for the service. (I am using the browser to view the results at this point only). </P><P>I am assuming it has something to do with serialization? But why is it displaying the derived class with all expected data, which yes does include the data not being displayed as a user data, I am calling the data using the same UserId. I am not expecting someone to inspect my code, but to be a traffic cop and point me in the direction I need to look.
I am looking for a solid tutorial on using the Entity Framework with POCO (ie. not using the designer) using MySQL as the back-end. I am looking for something that is semi-in-depth covering stuff like attributes (like how to map a database table/field name to a class/field name that is different). Also I am looking for C#, not VB. Does anyone know of any such tutorials?
View 3 RepliesCurrently im using EF and using its datacontext directly in all of my actions, but since i started reading about loose coupling and testability im thinking that thats not the best way to go. Im trying to understand all the pro's and con's before i start refactor all my current code.
Problem 1:
Considering that every entity needs its own repository, and thus has to setup its own connection to a datasource (lets assume a database using EF), wouldnt that give alot of overhead if i need data from 5 different entities on a single page?
Problem 2:
What im seeing aswell in all the examples which i found online is that most people (even people like shanselman) implement the repository pattern using the entity classes which are generated by either LINQ or EF, doesn't this defeat the purpose of repository pattern with regards to loose coupling? On the other hand, what is the alternative, using POCO classes in combination with for example AutoMapper? (this scares me a little) Im hoping that a few people can shed some light on this, because im a bit confused at the moment if the repository pattern is the right choice for a website.
I was wondering if anyone can point me in the right direction? I have a POCO model and I am using Code First CTP. In my application, I set the database to be recreated whenever the model changes.
I would like to write custom functionality to access the model (POCO) metadata same way as EF sees it and use that to generate some source files (using T4). I would like to access the processed model not having to worry about finding properties that hold primary keys or any other conventions (implicit or not). What is the way to go about it?
I want to put POCO object to Velocity cache. How can I serializable ICollection to Velocity cache, or exclude ICollection from serialization?
I got this exception
Type 'System.Collections.Generic.ICollection`1[Model.Collection]' cannot be serialized. Consider marking it with the DataContractAttribute attribute, and marking all of its members you want serialized with the DataMemberAttribute attribute. If the type is a collection, consider marking it with the CollectionDataContractAttribute. See the Microsoft .NET Framework documentation for other supported types.
I need a bug tracker software for our application development and sql script development (small 2-3 person team)...
I am new to asp.net MVC and thaught it would be nice if one was available built on the asp.net mvc platform and available with source code.
Is it possible to track bugs in a visual web developer website? I want to be able to step through the code so I can see exactly what it is doing but am not quite sure how to do this.
View 8 Repliesi am getting this error while tracking my datakey.. i am not sure why my datakey index is coming out of range.. here is my code :
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
var dataKeys = GridView1.DataKeys[e.Row.RowIndex];
dataKeys.Value.ToString();
Label1.Text = "The key field value for the displayed record is " + dataKeys.Value.ToString();
}
Header Part Of the GridView:
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White"
/>
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#999999" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
<script language="javascript" type="text/javascript">
function viewProfile(selectedRowIndex, firstName) {
//alert(firstName);
//var customGridView = document.getElementById('<%= CustomGridView.ClientID %>');
var customGridView = document.getElementById('GridView1');
if (customGridView) {
var row = customGridView.rows[parseInt(selectedRowIndex) + 1];
//var cell = customGridView.rows[parseInt(selectedRowIndex) + 1].cells[0];
// alert(row.cells[0].innerHTML);
// alert(row.cells[1].innerHTML);
// alert(row.cells[2].innerHTML);
// alert(row.cells[3].innerHTML);
// alert(row.cells[4].innerHTML);
window.open('detatil.aspx?coaid=' + row.cells[1].innerHTML + '&fnomia=' + row.cells[2].innerHTML, "", "scrollbars=no,height=300,width=300");
}
}
</script>
The error is: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
Yesterday i saw a site in which, site is listing the ip address and country name, saying that recently visited members (a list of ip address with country name,city name). Can i know how can i track that information any reference or any code.
View 1 Replies<IMG
src="filepate of image"
alt="Click to view this company's profile" [code]...
Above is the html code. The code says it has a picture which has two links. Now can anyone tell me how can i track on the click on image for a perticular url. Using asp.net say url1. I need to store the clicks report into the database using vb.net.
I have a ASP.Net wesite developed using c#, ASP.Net,Oracle and Ajax.I want to send an email to the user from HP Quality Center (QC) and get the result from the user and store it the Quality Center Defect.QC will automatically send the email.The user should be able to provide the result like (Yes/No) even from his mobile by accessing the email or a system.How can we keep track of the reply send by the user and using which method?I can take the help of my ASP.Net website to route the message.For Example, when the user send the reply,the website should be some how able to parse the email and store this into QC or database.
View 4 RepliesUsers can upload files to the server, which are stored effectively forever.
A few of my ideas involve logging every upload, but then the files are usually referenced in html which isn't easy to track.
Files can sit unused but still be referenced. I could do a fuill text search on these, but that's pretty brute force.
Is there a (free!) software/components that I can use to track how my web site is being used - which pages are most popular, how many times was the site visitied today, yesterday etc...
View 3 Replies