I'm trying to figure out how to bind an EF4.0 object to my textbox control. I have a call to my business object that returns an entity CFUser that has a FirstName parameter on it of type string. However, after I make the call and bind the object, the codebehind executes which fills the BindUser property with the correct value. However, nothing shows up in the textbox.
my aspx side is
[Code]....
I am trying to bind a Entity datasoruce in the code behind file with the following:
MembershipUser myUser = Membership.GetUser();
Guid userIdPosts = (Guid)myUser.ProviderUserKey;
//MessageBoardEntities3 is ThemeableAttribute connection string name
[code]...
I have this entity model>> http://img840.imageshack.us/img840/306/schemaj.jpg and I would like to bind a list which consists of: employee's
emloyee_firstname(employees table) + employee_lastname(employees table)employee's extension(employee_extension table)deparment name(departments table)to my gridview. I already created my stored procedure
[Code]....
i don't know how to bind it since i don't have an entity that contains the employee's name, extension# and departments name. Do I need to create a custom class that consists of said columns? or is their a proper way to do this? I'm using vs2008 3.5 framework.
i have 2 tables without any cascade deletind. i wont to delete parent object with all child objects. i do like this
//get parent object
return _dataContext.Menu.Include("ChildMenu").Include("ParentMenu").Include("Pictures").FirstOrDefault(m => m.MenuId == id);
//then i loop all child objects
var picList = (List<Picture>)menu.Pictures.ToList();
//foreach (var item in menu.Pictures)
for (int i = 0; i < picList.Count; i++)
{
if (File.Exists(HttpContext.Current.Server.MapPath(picList[i].ImgPath)))
{
File.Delete(HttpContext.Current.Server.MapPath(picList[i].ImgPath));
}
if (File.Exists(HttpContext.Current.Server.MapPath(picList[i].ThumbPath)))
{
File.Delete(HttpContext.Current.Server.MapPath(picList[i].ThumbPath));
}
//**what must i do here?**
//menu.Pictures.Remove(picList[i]);
// DataManager dm = new DataManager();
// dm.Picture.Delete(picList[i].Id);
//menu.Pictures.de
//_dataContext.SaveChanges();
//picList[i] = null;
}
//delete parent object
_dataContext.DeleteObject(_dataContext.Menu.Include("ChildMenu").Include("ParentMenu").Include("Pictures").FirstOrDefault(m => m.MenuId == id););
_dataContext.SaveChanges();
Tables: Article, Author, Comment (1 article and 1 author can have * comments)In the database is 1 article, 1 author and 1 comment.
The problem is, that code
myBD my_bd = new myBD();
var articles = by_bd.Article;
works OK, I can see that an Author and an Article has 1 comment. But that code
var comm = (from u in my_bd.Comment
where ......
select u);
returns the comment but it has NULL values in property Article and Author. Why ?
I am using C# with Entity Framework Model. I want to fill a textbox (tbPrepProbComment.Text ) with a string (S0PrepProbSolveComment) from a table (EightDProject). I'm getting the key for the EightDProject from a textbox (SelectTrackingNumber). I'm not sure my query is working because when I look at the query result ( project ) I see the error" 'mykey' could not be resolved in the current scope or context. Make sure that all referenced variables are in scope, that required schemas are loaded, and that namespaces are referenced correctly." If the query was working I dont know how to pull the field from the distinct row it should return and put it in the textbox. I've tried the line tbPrepProbComment.Text = project.S0PrepProbSolveComment; Here is my code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Objects;
namespace EightD1
{
public partial class Page1 : System.Web.UI.Page
{
public int mykey;
public string comment;
public object obj;
// the entity framework model
EightDdbEntities EightDP = new EightDdbEntities();
protected void Page_Load(object sender, EventArgs e)
{
SelectTrackingNumber.Focus();
}
//When the project id has been selected get projectdata and bind to page data holders
protected void SelectTrackingNumber_TextChanged(object sender, EventArgs e)
{
BindData();
}
private void BindData()
{
try
{
mykey = Convert.ToInt32(SelectTrackingNumber.Text.ToString());
}
catch
{
mykey = 0;
}
ObjectQuery<EightDProject> project = EightDP.CreateQuery<EightDProject>(
"SELECT DISTINCT p FROM EightDProjects AS p WHERE p.EightDID = mykey ");
//tbPrepProbComment.Text = project.S0PrepProbSolveComment;
}
}
}
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 create example using Northwind database so i create a new website and add new ADO.Net Entity Data Model (.edmx) called Northwind.edmx and i add Categories and Products table inside this (.edmx) file
and add new ADO.Net Data Servuce called "ADODataService" and add it as WebReferences called NorthwindService
so i add new web page and drag DropdownList and Gridview as i want to bind Dropdownlist to all categories and when i select category from Dropdownlist bind Gridview to all Products related to this category
so my code
[Code]....
and my code
[Code]....
so when i select category from Dropdownlist nothing happen :(
also you will find commented code in method BindCategory whuch is not work also.
We have an ASP.NET MVC site that uses Entity Framework abstractions with Repository and UnitOfWork patterns. What I'm wondering is how others have implemented navigation of complex object graphs with these patterns. Let me give an example from one of our controllers:
[code]....
It's a registration process and pretty much everything hangs off the POCO class Person. In this case we're caching the person through the registration process. I've now started implementing the latter part of the registration process which requires access to data deeper in the object graph. Specifically DPA data which hangs off Legal inside Country.
The code above is just mapping out the model information into a simpler format for the ViewModel. My question is do you consider this fairly deep navigation of the graph good practice or would you abstract out the retrieval of the objects further down the graph into repositories?
I'm in the process of deserializing a JSON object into an Entity Framework object. The property names in the JSON do not match up totally with the property names in the Entity Framework Objects. What I'd like to do is set "Name=" on the "DataContractAttribute" for the table and the "DataMemberAttribute" for the properties in the Designer.cs file. I tried setting these in the Designer.cs file manually just to see if it would work - which it did (using JSON.Net) but of course when I went into the .edmx designer I lost all my changes. Is there a way to do this?
View 1 RepliesI am new to entity framework , it is really very good , but I want to know what is the difference between using entity framework with stored procedure or without stored procedure , which one the faster and what is the benefits for using stored procedures with entity framework.
View 1 RepliesI 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 get an cast exception when i am trying to insert an entity in Entity Framework (using code-first). From this code :
public virtual T Insert(T entity)
{
return Context.Set<T>().Add(entity);
}
The cast exception is like "impossible to cast ...Collection'1(Entity) to type (Entity)" I can't figure out why. I am pretty sure ive done everything right. Post entity
public class Post
{
public long PostId { get; private set; }
public DateTime date { get; set; }
[Required]
public string Subject { get; set; }
public User User { get; set; }
public Category Category { get; set; }
[Required]
public string Body { get; set; }
public virtual ICollection<Tag> Tags { get; private set; }
public Post()
{
Category = new Category();
if (Tags == null)
Tags = new Collection<Tag>();
}................................
I am mapping a stored procedure to an entity by right clicking on the entity (in the .edmx) and selecting "Stored Procedure Mapping." This brings you to a Mapping Details - "Name of Entity" Window that allows you to select the insert, update, and delete stored procedures associated with the Entity. It also maps the stored procedure parameter to the Entity "Property" (Column).
I'm gettin an error "error 2042: Parameter Mapping specified is not valid." The cause of the error is fairly obvious, in the Insert stored procedure that has been selected, a 'CHAR' parameter is being mapped to an Int32 Entity Property. I altered the stored procedure parameter to match the entity, I deleted the stored procedure, readded, and reslected it as the Insert function. I also cleaned, validated, updated model from database. No matter what I do, the parameter list in the mapping details doesn't reflect the change to the stored procedure. It's stuck on a char --> int32 mapping, even though it has been changed, like it's buried deep in meta data some where.
I am trying to add a new entity and have to refernce associated data to add it. I cannot load the Referencetables. Giving "The EntityReference could not be loaded because it is not attached to an ObjectContext." How do i complete this task in Entity Framework 3.5
[Code]....
I have a stupid problem with the Entity Framework. I get the following Exception:
[Code]....
I have an entity with a 4 fields representing the primary key. I copy it via serialization (works fine). I set the old entity to not valid (Datefield set to a date in the past, this field is part of the PK) and set the copied entity to DateTime.Now.Date. When I call context.AddObject I get the Exception above. I tried copying the entity via reflection but the entity has 3-4 references. And when copied, I get another Exception before even Adding the entity to the context. I also tried setting newObj.EntityKey = null and reset all the fields neccessary for the PK. I just want a whole copy of an entity with a different primary key (and some other fields changed too) and Create it in the database.
I'm writing a custom .NET MembershipProvider (not the built in one) and trying to update using Entity Framework. But of course i have no access to (Try)UpdateModel. How can i update it?
View 3 RepliesI have an Events table and an InstallmentPlans table. The relationship is 0..1 : an Event can have 0 or 1 Installment plans. If I want to remove the existing InstallmentPlan for an event, how do I do this? Setting it to null doesn't seem to work:
_event.InstallmentPlan = null;
Here's a simple code snippet where I create a new Entity object and call SaveChanges() to create a new record in the mapped database table.
[Code]....
What I'm trying to figure out is whether there is a way to derive this new key for my entity, e, from the ObjectContext, m? The reason for this is that the way my actual code is structured, my entity object is already out of scope at the point where I call the SaveChanges() method.
I am trying to do something like this:
[Code]....
But ofcourse it is not working as I want to. The Ordering works on Question.Order, but I would also the
Questions.SubQuestions List to be ordered according to SubQuestions.Order
I have a web form with several DDL and text boxes some of them have post backs some dont
the DDLs have 3 or 4 Values like Yes , No or Often, Regularly, Never
a user is able to select the values and save his selection results on a sql server and a record number is generated on the save.
he is also able to retrieve his results via the same record number Via a subroutine called RecordSrchId all the text boxes get populated most of the DDLs get populated and results are selected but some of the DDLs dont get selected.
The DDLs for example will have Yes, No results as values in the list of items. The retrieved data from the sql is presented in a datatable and the value is cascaded down via the correct ID of the items for example "mydatatable.Tables(0).Rows(0)(2).ToString" where my datatable is the datatable and (2) is the item number i get a value from mydatatable as i have tested this with a Label control so its not returning null and the DDl have the correct list of values also in the correct case formats but for some reason it will give me an error below
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
Line 1148:
Line 1149: crane_requirement_Frequency_40T0.Items.FindByText(mydatatable.Tables(0).Rows(0)(32).ToString).Select ed = True Line 1150: Line 1151:
Source File: C:inetpubwwwrootaspxfactfindDefault.aspx.vb Line: 1149
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
FactFindMenu.recordidsrch() in C:inetpubwwwrootaspxfactfindDefault.aspx.vb:1149
FactFindMenu.Srch_Record_Click(Object sender, EventArgs e) in C:inetpubwwwrootaspxfactfindDefault.aspx.vb:1090
[code]....
the subroutine to retrive the date is below
Private Sub recordidsrch()
Dim searchFactfnd As New SearchFactFnd ' custom class used to retrive data From sql server
Dim mydatatable As New Data.DataSet ' Dataset/table used
mydatatable = searchFactfnd.FactFNDTableID(Rcrd_num_Txt.Text) ' populates the dataset with the function FactFNDTableID via a record Id gained from a textbox and function returns a dataset/table
contact_name.Text = mydatatable.Tables(0).Rows(0)(1).ToString
[Code]......
The HTML code dor the DDL is
<aspropDownList ID="crane_requirement_Frequency_40T" runat="server" CssClass="largeinput" AutoPostBack="True">
asp:ListItem>Crane Requirements Frequency</asp:ListItem>
<asp:ListItem>Regularly</asp:ListItem>
<asp:ListItem>Often</asp:ListItem>
<asp:ListItem>Seldom</asp:ListItem>
<asp:ListItem>Never</asp:ListItem>
</aspropDownList>
I have tried several variations of the below
Items.FindByText(mydatatable.Tables(0).Rows(0)(32).ToString).Selected =True
Items.FindByvalue(mydatatable.Tables(0).Rows(0)(32).ToString).Selected =True
ddl.selectedvalue
ddl.selecteditem
if not ispostback then
'populate
end if
ddl.clearcontents
tried rewriting the html ddl to below and try variations above did not work
<aspropDownList ID="crane_requirement_Frequency_40T" runat="server" CssClass="largeinputd">
<asp:ListItem Text="Crane Requirements Frequency"Value="" />
<asp:ListItem Text="Regularly" Value="Regularly" />
<asp:ListItem Text="Often" Value="Often" />
<asp:ListItem Text="Seldom" Value="Seldom" />
</aspropDownList>
i know the values fro the data set are correct and not null and the values exist in the DDL could post back be causing this.
If I develop a Windows User Control and host it inside an aspx web form, does the user's machine accessing the aspx page needs .NET Framework?
Does the Windows User Control hosted inside an aspx or web form requires any downloading of the control similar to an ActiveX control? Or Is it rendered like a HTML page?
I have textbox1 in Default.aspx vb.net page with textbox1.text="Sumit"
On button click event I redirect to Default2.aspx and in Default2.aspx when i click on LinkButton1 then i redirect back to Default.aspx
But then i see the textbox1.text will remove but i want the textbox1.text="Sumit" after i redirect to textbox1 again ..
I'm using VS 2008 with SP1. I want to use SP in the entity framework. The SP uses join of more than 1 table to return data. Most of the online examples I show, use the single table. How to return data of more than one tables?
View 4 Repliessolve this problemi create example using Northwind database so i create a new website and add new ADO.Net Entity Data Model (.edmx) called Northwind.edmx and i add Categories and Products table inside this (.edmx) fileand add new ADO.Net Data Servuce called "ADODataService" and add it as WebReferences called NorthwindServiceso i add new web page and drag DropdownList and Gridview as i want to bind Dropdownlist to all categories and when i select category from Dropdownlist bind Gridview to all Products related to this categoryso my code
[Code]....
and my code
[Code]....
so when i select category from Dropdownlist nothing happen :(also you will find commented code in method BindCategory whuch is not work also :(