.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
sivanagamahesh
Post New Web Links

Insert Muiple rows Into Table using Entity Framework ??

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :ASP.Net
 

Dear All,

 

i'm trying to use Entity Framework to insert into SQL SERVER 2005, using Visual studio 2008.

the following codes are a Button onclick event,

I want to insert into DB multiple rows at a time

protected void Button1_Click(object sender, EventArgs e)
    {
        MyTable NewRow = new MyTable();

        NewRow.columnName = "5";  //columnName is a primary key
        DbEntity.AddToAllowRevise(NewRow); 
        DbEntity.SaveChanges();

        NewRow.columnName = "6";
        DbEntity.AddToAllowRevise(NewRow);
        DbEntity.SaveChanges();
    }


however this does not work,

it seems we can only insert into DB only one row at a time (??)

if i write :

MyTable NewRow1 = new MyTable();

NewRow1.columnName = "5";

 

MyTable NewRow2 = new MyTable();

NewRow2.columnName = "6";

 

MyTable NewRow3 = new MyTable();

NewRow3.columnName = "7";

....

MyTable NewRow10 = new MyTable();

it will success.

but what if i have more rows, like 20~30 row? i have to seperately write 20~30

MyTable NewRow20 = new MyTable();  ........... MyTable NewRow30 = new MyTable();

 

?? sorry i'm a beginn


View Complete Post


More Related Resource Links

multiple insert rows using Entity Framework

  

Dear All,

 

i'm trying to use Entity Framework to insert into SQL SERVER 2005, using Visual studio 2008.

the following codes are a Button onclick event,

I want to insert into DB multiple rows at a time

protected void Button1_Click(object sender, EventArgs e) 
{ 
	MyTable NewRow = new MyTable(); 
	NewRow.columnName = "5"; //columnName is a primary key
	DbEntity.AddToAllowRevise(NewRow); 
	DbEntity.SaveChanges(); 
	
	NewRow.columnName = "6"; 
	DbEntity.AddToAllowRevise(NewRow); 
	DbEntity.SaveChanges(); 
} 


 

however this does not work,

it seems we can only insert into DB only one row at a time (??)

if i write :

MyTable NewRow1 = new MyTable();

NewRow1.columnName = "5";

 

MyTable NewRow2 = new MyTable();

NewRow2.columnName = "6";

 

MyTable NewRow3 = new MyTable();

NewRow3.columnName = "7";

....

MyTable NewRow10 = new MyTable();

it will success.

but what if i have more rows, like 20~30 rows? i have to seperately write 20~30

MyTable NewRow20 = new MyTable();  ........... MyTable NewRow30 = new MyTable();

 

?? sorry i'm a beginner now, please anybody can help? better idea?<

Data Points: Deny Table Access to the Entity Framework Without Causing a Mutiny

  

Julie Lerman shows database administrators how to limit access to databases from the Entity Framework by allowing it to work only with views and stored procedures instead of tables-without impacting application code or alienating developers.

Julie Lerman

MSDN Magazine August 2010


How to declare a table variable in SSIS and then insert rows into it

  
Hello everyone,   I'll try to explain my problem as clearly as I can: 1)I have an Execute SQL Task that's inside a Foreach Loop Container. 2)Inside the Execute SQL Task, I have an int OUTPUT column. 3)With each iteration, I need to insert the data from the INT output colum into a table variable. 4)After the Foreach Loop finishes the iterations, I need to use the table variable to create a report based on the data inside.   My question is the following: How can I declare a table variable so that I can do all of the above?   Thank you, CostinP

Conditional insert: If select return rows, insert rows to table otherwise insert specific row indica

  
This is what I have

Insert into ReportDetail( Partcipantid, Reportid)  

select distinct ParticipantID , 9 from OpenCredit

      except select ParticipantID, 9 from StoreCredit where Closed = 0

 Issue is that when above select statement returns no row, it seems like no record is

how to insert data present in different rows of same collumn of one table into same rows of differn

  

Hi,

I am have task that i have to insert data present in different rows of same collumn of one table into  same rows of differnt collumn of other table below shows the table structure source & distination

c_date                c_balance

11/1/2010          100

11/2/2010          200

11/3/2010          300

     ----                ----

  -----                ---

12/1/2010          150

12/2/2010          300

12/3/2010          400

   ---                  ----

   ----                  ---

like above i have thousands of data with other collumns

now i have the detination structure  as

Insert Entity from one table to another - EF4

  

Hello,

I have two tables: Residence and ResHistory. Residence contains current residence address information and ResHistory is an archive of past residence information.

Both tables contain a StartDate and an EndDate. In the Residence table the EndDate is always empty but if the user enters a date in this field when updating the record, I want to copy the record to the ResHistory archive table then create a new record in the Residence with the same userID.

I've found some references including this link on Execute Business Logic During Scalar Property Changes:
http://msdn.microsoft.com/en-us/library/cc716747.aspx but I'm not sure if this is the best approach. I'm sure someone has done something similar with EF and might provide some tips.

Thanks, Jeff


How to insert foreignkey in Entity framework in MVC

  

I m try to insert record to table, its working well without foreignkey using Entity model. But i need to insert foreign key. I used the following query, its not working well via Entity model.

objFacility.FacilityCategoryReference.EntityKey =

new System.Data.EntityKey("testEntities.test", "id", 10);

What i did wrong? or anything missed in my code. Please share your points

Thanks

Alagar.M


Entity Framework Table Mappings

  

Hi Everyone, I am busy developing an application using EF4 and MVC2. My development database has a few extra fields that is not in my production database. I have removed the fields from the Model, and published my application to my web server. But now I am getting errors that says I have some invalid column names, but I have removed it from my model. If I go to my Mapping Details, I see the fields removed from the Model are still there, but not mapped to anything.

Any ideas how to get around this problem?


Thanks,

Jacques


How to map an Entity framework model to a table name dynamically

  

I am working in MVC 3 with entity frame work so I am using List, create, edit and details page by razor templates of csHTML5.

But I have found one problem while creating a templates from my company model which Company table available in my existing database which I cannot change.

So all related controller and View has been created along with context, but Problem is comes that created entity framework structure is expected tables “Companies” but in my case I have table with company. Below


Multiple database support with Entity Framework

  
One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Insert value using Table Value Functions

  
a real gem in Sql Server 2008. mostly people still using Stored procedure may be they shifted to SQL Server but they are not using TVF right now.

Creating a Generic Entity Framework 4.0 Repository

  
With .NET 4.0 right around the corner, I thought it would be cool to download Visual Studio 2010 beta 2 and start playing around with the next release of Entity Framework.

The initial release of Entity Framework came with a great deal of criticism. To make matters worse, there was a large uproar when it was rumored that Microsoft would be abandoning LINQ to SQL, in favor of Entity Framework. This was because, at the time, many developers felt Entity Framework was an inferior technology to LINQ to SQL. To set things right, Microsoft proactively moved forward with improving Entity Framework, in time for the 4.0 release of the .NET Framework. This is good news because my initial impressions, so far, have been nothing but positive.

ASP.NET 4.0 Dynamic Data and Many to Many Entity Framework Entities

  
I did not play much with Dynamic Data controls in VS2008 and just made a cool discovery in VS2010 Beta 2. This may not even be new, but as I'm sitting 30,000+ feet over the Atlantic ocean, I don't have access to VS2008 at the moment to check.

Using jQuery to Filter Table Rows

  
The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:

Insert Rows with a GridView

  
In ASP.NET version 1.x, I used the footer on the DataGrid control to insert new rows by placing a series of TextBox, DropDownLists, CheckBoxes etc. controls on it and then handling a save button. This also works with the GridView in version 2.0 but with one major exception: if your data source is empty, the GridView will hide your footer (and header) and only display the EmptyDataText.

RadioButton Groups, Table Rows And NamingContainers in asp.net

  
The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes.

RadioButton Groups, Table Rows And NamingContainers

  
(In which AJAX-enhanced CheckBoxes become more useful than RadioButtons but inheritance saves the day, and a simple RadioButton-derived control establishes the purpose of a control's naming container)

The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend