ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2018 www.aspforums.com. All rights reserved.Write JOIN Queries using LINQ to SQL and Entity Framework in C# and VB.Net<p>Hello Everybody,</p> <p>I am having problems in joining tables using entity framework&nbsp;&nbsp;6.1.3</p> <p>help me by giving example with it is description and it syntax&nbsp;</p> <p>Suppose I want to Write the following queires using entityframework</p> <p><strong>INNER JOIN</strong></p> <p>SELECT Orders.OrderID, Customers.CustomerName<br />FROM Orders<br />INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;</p> <p><strong>LEFT JOIN</strong></p> <p>SELECT Customers.CustomerName, Orders.OrderID<br />FROM Customers<br />LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID<br />ORDER BY Customers.CustomerName;</p> <p><strong>RIGHT JOIN</strong></p> <p>SELECT Orders.OrderID, Employees.LastName, Employees.FirstName<br />FROM Orders<br />RIGHT JOIN Employees ON Orders.EmployeeID = Employees.EmployeeID<br />ORDER BY Orders.OrderID;</p> <p><strong>FULL OUTER JOIN</strong></p> <p>SELECT Customers.CustomerName, Orders.OrderID<br />FROM Customers<br />FULL OUTER JOIN Orders ON Customers.CustomerID=Orders.CustomerID<br />ORDER BY Customers.CustomerName;</p> <p><strong>SELF JOIN</strong></p> <p>SELECT A.CustomerName AS CustomerName1, B.CustomerName AS CustomerName2, A.City<br />FROM Customers A, Customers B<br />WHERE A.CustomerID &lt;&gt; B.CustomerID<br />AND A.City = B.City&nbsp;<br />ORDER BY A.City;</p> <p>thanks&nbsp;</p>https://www.aspforums.net:443/Threads/355491/Write-JOIN-Queries-using-LINQ-to-SQL-and-Entity-Framework-in-C-and-VBNet/https://www.aspforums.net:443/Threads/355491/Write-JOIN-Queries-using-LINQ-to-SQL-and-Entity-Framework-in-C-and-VBNet/Mon, 15 Jan 2018 00:37:39 GMTUsing Group By clause with Entity Framework in C# .Net<p>i have a scenario where i have to display the state name and number of cities in that state in autocompletet text how to do that</p> <p>&nbsp;</p> <pre class="brush: csharp">[HttpPost] public JsonResult find(string Text) { var suggestedUsers = (from x in lw.RWW_CountriesMaster where x.Country.StartsWith(Text) select new { country = x.Country, capital = x.Capital }).Distinct(); var count = (from x in lw.RWW_CountriesMaster where x.Country.StartsWith(Text) select new { country = x.Country, capital = x.Capital }).Count(); var result = suggestedUsers.Take(5).ToList(); //return result; return Json(result, JsonRequestBehavior.AllowGet); }</pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/106022/Using-Group-By-clause-with-Entity-Framework-in-C-Net/https://www.aspforums.net:443/Threads/106022/Using-Group-By-clause-with-Entity-Framework-in-C-Net/Wed, 17 Sep 2014 02:36:28 GMTUse Stored Procedure with Entity Framework in ASP.Net<p>hi</p> <p>how witre procuder or function in Entity framwork.</p> <p>please attend&nbsp; me i want create or write in Designing&nbsp; ef</p> <p>i dont want add from db sql</p> <p>&nbsp;</p> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/106181/Use-Stored-Procedure-with-Entity-Framework-in-ASPNet/https://www.aspforums.net:443/Threads/106181/Use-Stored-Procedure-with-Entity-Framework-in-ASPNet/Wed, 13 Mar 2013 00:34:27 GMTHow to tackle Slow INSERT for large amount of data in Entity Framework<p>hi,</p> <p>i'm using this code to update 10,000+ rows in entity framework. But it's taking more than 1 hour to compete transaction. Why it's taking too much time? Is there any solution of it?</p> <p>&nbsp;</p> <pre class="brush: csharp"> foreach (Property item in listProperties) { db.Properties.Attach(item); db.Entry(item).Property(x =&gt; x.pState).IsModified = true; } db.SaveChanges();</pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/767740/How-to-tackle-Slow-INSERT-for-large-amount-of-data-in-Entity-Framework/https://www.aspforums.net:443/Threads/767740/How-to-tackle-Slow-INSERT-for-large-amount-of-data-in-Entity-Framework/Fri, 25 Jul 2014 05:44:49 GMTHow to store binary files (BLOB) data using Entity Framework in C# .Net<p>Hi , I want to store binary files (blob)I searched many forums&nbsp; but didn't found !<br />My question is : how to store binary file (Doc , Pdf , txt..) type blob into database using Entity framework(edmx) With ASP.NET c#<br />please help !</p>https://www.aspforums.net:443/Threads/109129/How-to-store-binary-files-BLOB-data-using-Entity-Framework-in-C-Net/https://www.aspforums.net:443/Threads/109129/How-to-store-binary-files-BLOB-data-using-Entity-Framework-in-C-Net/Sun, 10 Nov 2013 23:44:44 GMTUsing Stored Procedure with Entity Framework in Linq query in ASP.Net<p>hi,</p> <p>I am trying to pass parameter to sp in an MVC controller.</p> <p>The stored procedure has a parameter that return a table from a string like 's1,s2,s3' (i have a Split Function in database).</p> <p>In Sql works fine but in my project i get model with no entities</p> <p>when i select the checkboxes that represent the multifilter i have no result</p> <p>I create a comma separated string when user checks the checkboxes that represent the product lines and then i use that string as parameter in stored procedure.</p> <p>i have a sp that works like</p> <pre class="brush: sql">select * from tab where produtLine In (select value from dbo.Split(COALESCE(@Linea,&#34;xxxx&#34;, &#34;,&#34;)...etc</pre> <p>the code in c# works but when i try to pass as Line Line1,Line2..etc I recive no result</p> <p>the code</p> <pre class="brush: csharp"> public ActionResult Index(String cliente, int ? anno, String [] linea, String tipoDati ) { String Codage = &#34;000&#34;; tipoDati = &#34;Ordini&#34;; string lineeSelezionate = null; cliente = cliente == &#34;cliente&#34; ? null : cliente; if (linea != null) { foreach (var item in linea) { lineeSelezionate += item + &#34;,&#34;; } lineeSelezionate = &#34;&#39;&#34; + lineeSelezionate.Substring(0, lineeSelezionate.Length - 1) + &#34;&#39;&#34;; } IEnumerable&lt;OrdineMeseLineaView&gt; model; if (string.IsNullOrEmpty(cliente) &amp;&amp; anno == null &amp;&amp; linea == null) { model = new List&lt;OrdineMeseLineaView&gt; { new OrdineMeseLineaView { Linea = &#34;&#34;, Gen = 0, Feb = 0, Mar = 0, Apr = 0, Mag = 0, Giu = 0, Lug = 0, Ago = 0, Set = 0, Ott = 0, Nov = 0, Dic = 0,Tot=0} }; } else { model = db.Database. SqlQuery&lt;OrdineMeseLineaView&gt;(&#34;dbo.PivotOrdiniMeseLineaSp @p0, @p1,@p2, @p3&#34;, Codage, (object)cliente ?? DBNull.Value, (object)anno ?? DBNull.Value, (object)lineeSelezionate ?? DBNull.Value).ToList(); } return View(model); }</pre>https://www.aspforums.net:443/Threads/176712/Using-Stored-Procedure-with-Entity-Framework-in-Linq-query-in-ASPNet/https://www.aspforums.net:443/Threads/176712/Using-Stored-Procedure-with-Entity-Framework-in-Linq-query-in-ASPNet/Mon, 13 Nov 2017 06:44:51 GMTUsing reflection to loop through related tables in entity object in ASP.Net<p>Hi there&nbsp;</p> <p>&nbsp;</p> <p>I need some help how do i&nbsp;using reflection to loop through related tables in entity object. so that i can find if and entitiy object is been used in any of the other tables</p>https://www.aspforums.net:443/Threads/122641/Using-reflection-to-loop-through-related-tables-in-entity-object-in-ASPNet/https://www.aspforums.net:443/Threads/122641/Using-reflection-to-loop-through-related-tables-in-entity-object-in-ASPNet/Fri, 24 Jun 2016 02:25:03 GMTUse Output Parameter with Entity Framework (Edmx) in C# .Net<p>I have develop a function to add textbox value into data base my function work perfectly .now I am using that table primary key into another table where it declare as a foreign key now i required to return my Id as a output parameter in table1 &nbsp;means( set scope identity) &nbsp;&nbsp;&nbsp;so that I used this Id into another table as a foreign key please help me how I used this scope identity into a web method</p> <pre class="brush: js">function Insertdata() { var name = $(&#39;#txtfname&#39;).val(); $.ajax({ type: &#39;POST&#39;, url: &#34;Insert.aspx/DataInsertion&#34;, contentType: &#34;application/json; charset=utf-8&#34;, data: &#39;{name:&#34;&#39; + name + &#39;&#34;, Id:&#34;&#39; + output + &#39;&#34;}&#39;, async: false, success: function (response) { alert(&#34; Saving the Data.!&#34;); }, error: function () { alert(&#34;Some Error occured While Saving the Data.!&#34;); } }); }; </pre> <p>&nbsp;</p> <pre class="brush: csharp">Web method [WebMethod] public static string DataInsertion(string name Id output) { using (var db = new MyEntities())///////this is edmx name { db.Insertion( Name=name, Id=Output ); } return &#34; Data Successfully Saved&#34;; } </pre> <p>I read a lot of article but I have no idea to use it.</p> <p>Please help me&nbsp;</p>https://www.aspforums.net:443/Threads/787562/Use-Output-Parameter-with-Entity-Framework-Edmx-in-C-Net/https://www.aspforums.net:443/Threads/787562/Use-Output-Parameter-with-Entity-Framework-Edmx-in-C-Net/Fri, 07 Aug 2015 09:26:31 GMTUnable to add Namespace using Entity Framework in ASP.Net<p>I'm follow your code(<a href="https://www.aspsnippets.com/Articles/Entity-Framework-CRUD-Select-Insert-Edit-Update-Delete-using-Entity-Framework-in-ASPNet.aspx">code link</a>) from here. but I don't understand where I use AddToCustomers Method and I'm unable to Add NameSpace "TestModelNs".<br />Here is my aspx file(<a href="https://drive.google.com/open?id=1fzU9WAc92-45cYJU62Ca469KPCMe7gF0">files link</a>)</p>https://www.aspforums.net:443/Threads/598370/Unable-to-add-Namespace-using-Entity-Framework-in-ASPNet/https://www.aspforums.net:443/Threads/598370/Unable-to-add-Namespace-using-Entity-Framework-in-ASPNet/Sun, 03 Dec 2017 01:05:54 GMTSystem.Data.SqlClient.SqlException: Invalid object name 'Phase1'<p>Hi....,</p> <p>I got an error of&nbsp;System.Data.SqlClient.SqlException: Invalid object name 'Phase1'like this but in my code there is no Phase1..what should i do..plz help me...</p>https://www.aspforums.net:443/Threads/164268/SystemDataSqlClientSqlException-Invalid-object-name-Phase1/https://www.aspforums.net:443/Threads/164268/SystemDataSqlClientSqlException-Invalid-object-name-Phase1/Tue, 16 Sep 2014 10:04:10 GMTSum of DataTable columns total using Lambda Expression in Entity FrameWork in ASP.Net<pre><font color="red"> decimal total = dt.AsEnumerable().Sum(row =&gt; row.Field&lt;decimal&gt;("TotalAmount"));<br /><br /><br /><br />when i try to add the total amount from grid view row then i'm faicing above error sir</font></pre>https://www.aspforums.net:443/Threads/861050/Sum-of-DataTable-columns-total-using-Lambda-Expression-in-Entity-FrameWork-in-ASPNet/https://www.aspforums.net:443/Threads/861050/Sum-of-DataTable-columns-total-using-Lambda-Expression-in-Entity-FrameWork-in-ASPNet/Mon, 19 Dec 2016 05:15:01 GMTSum of Column using Linq Lambda Expression in ASP.Net<p>how to use &nbsp;this Query in linq Lamda Expression&nbsp;</p> <pre class="brush: sql">Select&nbsp; sum(AmountPaid) as TotalAmountPaid from StudentLedger where FeeTypeID in&nbsp;(1,2) and StudentID =639</pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/124499/Sum-of-Column-using-Linq-Lambda-Expression-in-ASPNet/https://www.aspforums.net:443/Threads/124499/Sum-of-Column-using-Linq-Lambda-Expression-in-ASPNet/Fri, 18 May 2018 01:12:37 GMTPopulate Windows Forms ComboBox control using Entity Framework<p>HI,<br /> &nbsp;<br /> I tried to show list of name on cmbobox<br /> &nbsp;<br /> <br /> this is the code(query<br /> var query = (from p in dbhome.Stores select new { p.FNameware,p.id }).ToList();<br /> Cbox.DataSource = query.ToList();</p>https://www.aspforums.net:443/Threads/135727/Populate-Windows-Forms-ComboBox-control-using-Entity-Framework/https://www.aspforums.net:443/Threads/135727/Populate-Windows-Forms-ComboBox-control-using-Entity-Framework/Sat, 09 Mar 2013 07:21:53 GMTPM EntityFramework -Version 6.0.0-alpha1 -Pre The term EntityFramework is no<p>hi when install EntityFramework -Version 6.0.0-alpha1 -Pre in asp.net</p> <p>&nbsp;</p> <p>i see this error</p> <p>PM&gt; EntityFramework -Version 6.0.0-alpha1 -Pre <br />The term 'EntityFramework' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify<br />&nbsp;that the path is correct and try again.<br />At line:1 char:16<br />+ EntityFramework &lt;&lt;&lt;&lt;&nbsp; -Version 6.0.0-alpha1 -Pre <br />&nbsp;&nbsp;&nbsp; + CategoryInfo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : ObjectNotFound: (EntityFramework:String) [], CommandNotFoundException<br />&nbsp;&nbsp;&nbsp; + FullyQualifiedErrorId : CommandNotFoundException</p> <p>&nbsp;</p> <p>whats problem for me?<br />&nbsp;</p>https://www.aspforums.net:443/Threads/206189/PM-EntityFramework--Version-600-alpha1--Pre-The-term-EntityFramework-is-no/https://www.aspforums.net:443/Threads/206189/PM-EntityFramework--Version-600-alpha1--Pre-The-term-EntityFramework-is-no/Fri, 29 Mar 2013 08:48:39 GMTObject Name dbo.Poste invalid. or Object Name dbo.User invalid in Entity Framework<p>I am developing an ASP .Net MVC 3 application using C# and SQL Server 2005.</p> <p>I've created 2 models (User &amp; Poste) with their controllers (UserController &amp; PosteController) thanks to the method of creation with 'Read/Write actions and views, using Entity Framework'.</p> <p>When i would like to access to the view of User or Poste, that's mean when I put /Poste (or /User) in my URL to access to the index, this error appears to me :</p> <p>&nbsp;</p> <pre class="brush: xml">Object Name &#39;dbo.Poste&#39; invalid. or Object Name &#39;dbo.User&#39; invalid.</pre> <p><span>This is the model of User :</span></p> <p><span><br /></span></p> <pre class="brush: csharp">using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; using System.Globalization; using System.Web.Mvc; using System.Web.Security; using System.Data.SqlClient; using System.Data.Entity; namespace MvcApplication2.Models { public class User { [Required] [Key] [Display(Name = &#34;Matricule :&#34;)] public string Matricule { get; set; } [Required] [Display(Name = &#34;Nom :&#34;)] public string Nom_User { get; set; } [Required] [StringLength(100, ErrorMessage = &#34;Le {0} doit avoir au minimum {2} caract&egrave;res.&#34;, MinimumLength = 6)] [DataType(DataType.Password)] [Display(Name = &#34;Mot de passe :&#34;)] public string passWord { get; set; } [Required] [Display(Name = &#34;Type :&#34;)] public string Type_User { get; set; } [Required] [Display(Name = &#34;ID_UF :&#34;)] public string ID_UF { get; set; } } }</pre> <p>this is the Controller of User :</p> <div>&nbsp;</div> <pre class="brush: csharp">using System; using System.Collections.Generic; using System.Data; using System.Data.Entity; using System.Linq; using System.Web; using System.Web.Mvc; using MvcApplication2.Models; namespace MvcApplication2.Controllers { public class UserController : Controller { private GammeContext db = new GammeContext(); // // GET: /User/ public ViewResult Index() { return View(db.Users.ToList()); } // // GET: /User/Details/5 public ViewResult Details(string id) { User user = db.Users.Find(id); return View(user); } // // GET: /User/Create public ActionResult Create() { return View(); } // // POST: /User/Create [HttpPost] public ActionResult Create(User user) { if (ModelState.IsValid) { db.Users.Add(user); db.SaveChanges(); return RedirectToAction(&#34;Index&#34;); } return View(user); } // // GET: /User/Edit/5 public ActionResult Edit(string id) { User user = db.Users.Find(id); return View(user); } // // POST: /User/Edit/5 [HttpPost] public ActionResult Edit(User user) { if (ModelState.IsValid) { db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction(&#34;Index&#34;); } return View(user); } // // GET: /User/Delete/5 public ActionResult Delete(string id) { User user = db.Users.Find(id); return View(user); } // // POST: /User/Delete/5 [HttpPost, ActionName(&#34;Delete&#34;)] public ActionResult DeleteConfirmed(string id) { User user = db.Users.Find(id); db.Users.Remove(user); db.SaveChanges(); return RedirectToAction(&#34;Index&#34;); } protected override void Dispose(bool disposing) { db.Dispose(); base.Dispose(disposing); } } }</pre> <p><span>and this the context Class (GammeContext) :</span></p> <p><span><br /></span></p> <pre class="brush: csharp">using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data.Entity; namespace MvcApplication2.Models { public class GammeContext:DbContext { public DbSet&lt;Poste&gt; Postes { get; set; } public DbSet&lt;User&gt; Users { get; set; } protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Conventions.Remove&lt;System.Data.Entity.ModelConfiguration.Conventions.PluralizingTableNameConvention&gt;(); } } }</pre> <p><span>and this is what I added in my web.config file :</span></p> <p><span><br /></span></p> <pre class="brush: xml">&lt;add name=&#34;GammeContext&#34; connectionString=&#34;Data Source=SWEET-DE396641E\SQLEXPRESS;database=Flux; Integrated Security=true&#34; providerName=&#34;System.Data.SqlClient&#34; /&gt;</pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/479544/Object-Name-dboPoste-invalid-or-Object-Name-dboUser-invalid-in-Entity-Framework/https://www.aspforums.net:443/Threads/479544/Object-Name-dboPoste-invalid-or-Object-Name-dboUser-invalid-in-Entity-Framework/Thu, 02 May 2013 02:35:15 GMTMultiple Where conditions in Entity Framework C# .Net<p>i want to get one record <br />with multi condition <br />for example username == "me" and age grather than 20<br />please help me</p>https://www.aspforums.net:443/Threads/895519/Multiple-Where-conditions-in-Entity-Framework-C-Net/https://www.aspforums.net:443/Threads/895519/Multiple-Where-conditions-in-Entity-Framework-C-Net/Mon, 15 Sep 2014 04:38:51 GMTJoin multiple Tables using Entity Framework in Linq query using C# in ASP.Net<p>I have 2 tables</p> <p>first is tbl_News and 2nd is tbl_Category.</p> <p>1st tables has ID,Description,Date,Status,City and CategoryID</p> <p>2nd tables has Id,CategoryName. &nbsp; i want to show all columns of news table but i want to show categoryName in place of CategoryID</p> <pre class="brush: csharp">var News = from n in tbl_News join c in tbl_Category on n.CategoryId equals c.CategoryID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select new { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID = n.ID, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Description = n.Description, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date = n.Date, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status = n.Status, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; City = n.City, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Category = c.CategoryName &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }.ToList();</pre> <p>Here 1 got error tbl_category is type, not a valid in given context.</p> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/959152/Join-multiple-Tables-using-Entity-Framework-in-Linq-query-using-C-in-ASPNet/https://www.aspforums.net:443/Threads/959152/Join-multiple-Tables-using-Entity-Framework-in-Linq-query-using-C-in-ASPNet/Tue, 13 Feb 2018 23:49:31 GMTInserting into multiple Table using Entity Framework in ASP.Net<p>Hi ,</p> <p>&nbsp;I have a registration page fields are : username , Address , phoneno.</p> <p>i have 3 tables in data base :</p> <p>User : user id primary key , username</p> <p>Address : user id primary key , address&nbsp;</p> <p>Contact : user id , phoneno</p> <p>i am using entity frame work so i got 3class defaultly.</p> <p>now requirement is when i click on register button those fields i have to insert into those &nbsp;3 tables in a proper way</p> <p>Please help regarding this&nbsp;</p>https://www.aspforums.net:443/Threads/134214/Inserting-into-multiple-Table-using-Entity-Framework-in-ASPNet/https://www.aspforums.net:443/Threads/134214/Inserting-into-multiple-Table-using-Entity-Framework-in-ASPNet/Mon, 29 Feb 2016 06:27:12 GMTInsert Repeater rows to Database using Entity Framework in ASP.Net<p>hello&nbsp;</p> <p>&nbsp;</p> <p>i'm trying to insert multiple repeater rows into database but i failed todo that.&nbsp;</p> <p>this what i'm trying to do:</p> <p>&nbsp;</p> <p>&nbsp;</p> <pre class="brush: csharp">foreach (RepeaterItem item in Repeater1.Items) { if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem) { Label lblItemNo = (Label)item.FindControl(&#34;lblItemNo&#34;); Label lblCampCode = (Label)item.FindControl(&#34;lblCampCode&#34;); Label lblUom = (Label)item.FindControl(&#34;lblUom&#34;); Label lblBalUnits = (Label)item.FindControl(&#34;lblBalUnits&#34;); Label lblWT = (Label)item.FindControl(&#34;lblWt&#34;); //TextBox txtExitUnits = (TextBox)item.FindControl(&#34;txtExitUnits&#34;); Label lblExitUnits = (Label)item.FindControl(&#34;lblExitUnits&#34;); Label lblcode = (Label)item.FindControl(&#34;lblCode&#34;); HiddenField hfcode = (HiddenField)item.FindControl(&#34;hfCustomerId&#34;); TempExit temp = new TempExit(); temp.tmex_itemno = lblItemNo.Text; temp.tmex_gooddesc = lblCampCode.Text; temp.tmex_UOM = lblUom.Text; temp.tmex_wtbalance = decimal.Parse(lblWT.Text); temp.tmex_unitsbalance = decimal.Parse(lblBalUnits.Text); temp.tmex_ExitUnits = decimal.Parse(lblExitUnits.Text); db.TempExits.Add(temp); db.SaveChanges(); //Response.Redirect(&#34;sendingaspx.aspx&#34;); } }</pre> <p>but i got the following error:</p> <p><strong>Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.</strong></p> <p>&nbsp;</p> <p><strong>can any one help me?</strong></p>https://www.aspforums.net:443/Threads/174431/Insert-Repeater-rows-to-Database-using-Entity-Framework-in-ASPNet/https://www.aspforums.net:443/Threads/174431/Insert-Repeater-rows-to-Database-using-Entity-Framework-in-ASPNet/Sun, 04 Dec 2016 07:53:27 GMTInsert image with query into Entity Framework Database in ASP.Net<p>i have these table:&nbsp;</p> <pre class="brush: sql">CREATE TABLE [dbo].[Images] ( [Id] INT IDENTITY (1, 1) NOT NULL, [Name] NVARCHAR (MAX) NULL, [ContentType] NVARCHAR (MAX) NULL, [Data] VARBINARY (MAX) NULL, [Base64String] NVARCHAR (MAX) NULL, CONSTRAINT [PK_dbo.Images] PRIMARY KEY CLUSTERED ([Id] ASC) ); </pre> <p>Can you help me how to write query to insert image?</p>https://www.aspforums.net:443/Threads/184954/Insert-image-with-query-into-Entity-Framework-Database-in-ASPNet/https://www.aspforums.net:443/Threads/184954/Insert-image-with-query-into-Entity-Framework-Database-in-ASPNet/Wed, 16 Mar 2016 06:21:22 GMT