DataSource Controls :: Inserting Related Entities?
Mar 5, 2010Inserting Related Entities?
View 14 Replies
Similar Messages:
ADO.NET :: EF Saving Related Entities?
Aug 11, 2010Having the following model Admin and AdminGroup is joined by AdminAdminGroup which has (AdminId, AdminGroupId) fields. When I add a new Admin row AdminGroups are associated with it automatically however this only works on INSERT.When I'm trying to update or associate more AdminGroup's with particualr Admin row (_repo.Update((DataLayer.Admin)row);) only Admin gets updated and no groups are ever modified.What is the correct way of updated "related" entities? so that AdminGroup also get's updated.
View 6 RepliesWeb Forms :: Tables In LINQ To Entities Are Not Related
Aug 3, 2010I'm working with asp.net 3.5 WebForms and LINQ to Entities.
I created the database with their relationships, but when I go to import the data with LinqToEntities, some reports and have not seen any reports 1 to 1.
I can create them after the reports have imported the tables LinqToEntities?
ADO.NET :: Generate Id For Set Of Entities When Inserting?
Dec 23, 2010I have I method where I insert muliple records to a SQL Server 2008 database. The table in which the records are inserted has a primary key integer column with auto increment. The problem is that I have another column called GroupId where I want an integer representing the current insert to be set, i.e. for each time the method gets called a new group id should be generated the group id column of the records to be inserted should be set to this value. What's the best way to generate this group id? I guess I could do a SELECT MAX(GroupId) + 1 FROM Table to generate an id before I make the inserts but this won't be a good solution when it comes to concurrency.
View 13 RepliesADO.NET :: Inserting Data With LINQ To Entities?
Aug 11, 2010have already used the latest technology in a professional manner. NETBasically I have two tables related 1 to 1:the Users table and the table ProfiloPersonale is the key to the Users table that this table are ProfiloPersonale iduser and type uniqueidentifier and diagram sql server 2008 I can clearly see the report, I also did a test to insert a record in the users table ( fictional) directly from sql server and everything works.With LINQ to Entities does not work:The entities 'LEntities.Users' part of the eport 'ProfiloPersonale'.Found 'ProfiloPersonale' related to 0.Expected 1 'ProfiloPersonale'Of course what I am doing is to first create the user and then create their profile in the db, taking the id of the registered
View 1 RepliesMVC :: Entities - Inserting Child Elements From The View?
Feb 27, 2011I'm trying to create a view that will allow me to create an entity record and also child entities for that record. I have an entity type called "Parent" and I have a child entity called "Child". I want to be able to allow the user to create a Parent including adding several Children and their details, and the npost them all back to the controller from a single view. I found an example on how I would kind of do something like this here: [URL]. The problem with that example is that you can't refer to entities using bracket notation so it only works for those lists. Is there a way to insert hierarchical entity data using MVC from a single view in a single post back?
View 3 RepliesMVC :: Inserting Multiples Entities In A Same Transaction With Ef4 In A Project?
Dec 20, 2010in an mvc controller i need to insert the input data of the user, but that info is splitted in differents entities(differents related tables in the database, but not all tables are related), and i need to insert all info in a same transaction,(so that if one throws an insertion error or another error, undo all the previous changes maded ) how can afford that? or what is the best way to do that?
i am using a project for a repository, just basic data access stuff, a service project that implement my business logic, and my mvc project.
now i am inserting each entity separately, but if any error occurs, all the previous changes to the error still in the db, so with the time i ll have a very dirty db.
DataSource Controls :: Add Entities Using EF?
Apr 20, 2010I have the following admx:
I have to add the (AccData, CntactData, PhnNumber, FnclDetail)entities to the database in one shot
What's the best practices to do the add operation for the above entities??
DataSource Controls :: Is There A Way To Connect Two Entities Together In One New Entity
May 22, 2010And not doing a View that connect two tables ?Is there a way to connect two entities together in one new entity?
View 1 RepliesDataSource Controls :: Generating Tables From Entities
May 13, 2010I'm creating entity on a project to use them as data on my website. I got my base simple entity Users and my DataContext. The thing is i would like the database to create the table as i create Entities.
I mean, actually my database doesn't have a Users table and do not generate it as i build and launch the project. I used to be a Java dev and in Java the table can be created with JPA so i guess Microsoft made it possible with ASP.net but how to do? I've looked on the web but didn't find it.
DataSource Controls :: Update Method Using SQL To Entities
Apr 14, 2010I'm having a question about an update method using SQL To Entities. I'm sending an object to the class and i'm updating him sucefully, but i need to specify each property of object instead of update in once. For example
[Code]....
In this case, i'm updating name, age and country sucefully but i want to use instead of update each property one-by-one, something like this:
[Code]....
So, the C = New should fill the C with all New values on properties, but this isn't work. To update an object, i've to update each property individual or can i update all in one like C = New?
DataSource Controls :: Sql Server Network Related Error?
Jun 2, 2010I have the folloing sql server error from my ASP.NET website.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
This seems to be a network related issue. But on the same machine where IIS is running, I have another C# application running that is not experiencing this problem. This happens after the website has been running for a few weeks. Will this be because the database connections are opened but not closed properly?. I wrote a test web page where i just open connection but not close it and I got Time out error when connection pooling is maxed out. Is this memory issue? Memory that are allocated are not deallocated in timely fashion?..
Everything is working fine for a few weeks and after that I get the above network error.
DataSource Controls :: EntityDataSource With Include For Related Columns
Feb 28, 2011I have a formview with an entityDataSource. I need to include columns from related fields. I have seen many demos, with AdventureWorksDB, that imply that you can do this by using INCLUDE in the entitydatasource declaration. I have tried made many attempts and it just does not seem to work as demonstrated. I have attached the errors below and the EDS. I have also attached a JPEG of the model I am working in. Three errors demonstrating 3 different attempts to include a related table:
DataBinding: 'TmModel.tbICObjectBase' does not contain a property with the name 'Group'
the code declaration for error 1:
<asp:Label ID="Label1" runat="server" Text='<%# Bind("Group") %>' />
DataBinding: 'TmModel.tbICObjectBase' does not contain a property with the name 'tbICTagBase'.
the code declaration for error 2:
<asp:Label ID="Label1" runat="server" Text='<%# Bind("tbICTagBase.Group") %>' />
DataBinding: 'System.Data.Objects.DataClasses.EntityCollection`1[[TmModel.tbICTagBase, TmModel, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]' does not contain a property with the name 'Group'.
the code declaration for error 3:
<asp:Label ID="tbICTagBasesLabel" runat="server" Text='<%# Bind("tbICTagBases.Group") %>' />
EntityDataSource
<asp:EntityDataSource ID="entDSObjectBase" runat="server" AutoGenerateWhereClause="True"
ConnectionString="name=IntouchDBContainer" Include="tbICTagBases"
DefaultContainerName="IntouchDBContainer" EnableFlattening="False"
EntitySetName="tbICObjectBases" EnableDelete="True" EnableInsert="True"
EnableUpdate="True" EntityTypeFilter="tbICObjectBase">
<WhereParameters>
<asp:SessionParameter SessionField="Tag" Name="RecID" Type="Int64" />
</WhereParameters>
</asp:EntityDataSource>
You can see the model at [URL] Or [URL]
DataSource Controls :: How To Delete Related Data / Rows
May 5, 2010How to delete related data.
Ex:
Tables:
1) Account: ID,UserName,Pass
2) Campaign: ID,AccountID,Date,Balance
3) CampaignSpec: ID,CampaignID,Spec,Color
Note: Account.ID = Campaign.AccountID and Campaign.ID = CampaignSpec.CampaignID
DataSource Controls :: Get Record Count With Related Table?
May 17, 2010I want to get record count from below example.
I made two tables. One is club_info and another one is club_members.
And each table has data like following
[club_info]
club_id
club_name
:
[club_members]
mem_id
club_id
:
I want to get club_name and the member count for selected club_id and want to return the result as sqldatareader.
DataSource Controls :: All The Related Records Across Tables At The Same Time?
Mar 19, 2010Let say you read a customer record into Customer object. Do it read all the related records across tables at the same time Or it only reads when you do from o in customerobject.orders
View 2 RepliesDataSource Controls :: Editing Data With Linq To Entities
May 21, 2010I'm trying to update data with the EF I can't seem to get the EntityKey when I debug and hit this line befor I save changes _entities.ApplyPropertyChanges entityToEdit.EntityKey .EntitySetName, blogEntryToEdit); The EntityKey is null dose anyone have any idea how this key is set can't SaveChanges() without it _entities.ApplyPropertyChanges(entityToEdit.EntityKey .EntitySetName, blogEntryToEdit);
View 6 RepliesDataSource Controls :: Can Get Two Tables In Only One Query With LINQ To Entities
May 20, 2010can get two tables in only one query with LINQ to Entities
Code for example:
[Code]....
DataSource Controls :: Perform A Search For Records In Linq-to-Entities?
Jan 26, 2010I trying to create a search mechanism for records in a EDM based on text entered on a text box in a web page.
For example, if I enter a partial name of a customer and/or state abrebiation for that customer on the Text Box (abc, TX)s, I want to search name and state fields in a Customer table in my database for matching customers.
I found a solution with the namespaceSystem.Linq.Dynamic, but for some reason it is not working. It does not expose the Search() method. Here is the code I am using to perform the search;
[Code]....
DataSource Controls :: Inserting Data With Object Datasource?
Aug 9, 2010This is the first time I have been working on databases and I am trying to insert data using an object datasource but no data is being inserted and no exception is thrown. I'm not sure where I am going to wrong. I am putting user data into session variables and inserting the session variables into the dataacess class layer and have a try and exception but nothing being thrown. Any help would be really appreciated because I don't know even where to start looking with this or how I can get the error to be thrown. Please see some of my code below to give an idea of what I am doing
Object Access Class
public void InsertCarPolicyHolder(PolicyHolderClass ph, CarInsuranceOptions options)
{
[code]...
DataSource Controls :: Best Way To Handle Inserts For Entities When Using FormViews And Entity Framework 4?
Mar 3, 2010I am trying to get some guidance with this issue:
I have a Customer object that has two address ID fields (one for HomeAddress and one for WorkAddress)
I am loading the Address Objects by using Include="HomeAddress, WorkAddress" and then binding to the properties using the Navigation Property on the Customer Entity
Can I use just one FormView for doing the Insert/Updates and binding it to an EntityDataSource or would I have to do all the Inserting/Updating manually?
DataSource Controls :: Dynamic Linq To Entities...querying Date Fields?
Mar 9, 2010I am trying to use Linq to Entities with the Linq.Dynamic library (via Scott Guthrie) and I'm having some strange issues with querying dates.
[Code]....
This return no results, when it definitely should...
DataSource Controls :: Batch Update A Dataset Table Which Data Are From Related Tables?
Jun 8, 2010My dataset table data is from multiple tables (showing on a gridview),How to update the database tables using batch udpate on clicking submit, if the data is from a signle table, no problem, but I am not sure how to handle if the datais from mulitiple tables? If I have related tables, do I need put them in differet tables in the dataset?
View 6 RepliesDataSource Controls :: Linq Query To Select Parent Records Which Have Related Children
Jan 19, 2010I have a basic CMS which I'm adding to a site to display some downloads organised into groups. I have two tables, one for the groups and one for the downloads. I'm using a repeated to display the groups with another repeater inside to display the children. This works perfectly.
However some of my download groups may not have any downloads related to them and I'd like to handle this by filter the groups so that only those with a relate download record(s) are shown.
I'm trying to do this with the query which populates the top repeater based on some ideas I read but I must be going wrong with the syntax.
Here is what I'm using to try and only select downloads groups which have downloads linked to them by the download group ID.
[Code]....
Can anyone offer any thoughts on how I should construct the query to perform this?
DataSource Controls :: Linq To Entities - Multilevel Projection Into Business Class And Not Breaking Deferred Execution?
Mar 18, 2010I have a problem. (this a simplfied example)
In Entity framework I have a class which is effectively
fooEntity
{
public Guid Id {get; set;}
and a collection of fooChildEntity
}
a fooChildEntity is again an entityframework class
fooChildEntity
{
public Guid kidId {get; set;}
}
Now I also have a pair of business layer classes foo and fooChild
foo
{
public Guid Id {get; set;}
ilist<fooChild> Children {get;set;}
}
fooChild
{
public Guid kidId {get; set;}
}
My aim is to write a linq to entites that will allow me to convert the entity foo and children into the business foo and children without breaking deferred execution ( I will be adding filters to reduce the recordset at a higher coding level in the business layer)
doing something like
this.context.fooEntity
.include(fooChildEntity)
.Select( fe => new foo { Id=fe.Id ,
fe.foreach(fec => Children.add( new fooChild { kidId = fec.kidId}))})
.AsIQueryable()
is plainly rubbish and would never compile - it is however an indication of the direction I was thinking .
Even if I got a foreach to work like that or similar it would break deferred execution
At this point there are around 300,000 foo entities which I will eventualy filter to 5 or 6 foo's - this is why deferred execution is needed.