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 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 GMTSelect specific Columns in Entity Framework using Linq query in ASP.Net<p>&nbsp;</p> <pre class="brush: csharp"> var res = tbb.tbl_Enquiry.Where(x =&gt; x.Enq_broker == enq).ToList();</pre> <p>I Want to get not all column some specific column from tbl_Enquiry&nbsp;</p>https://www.aspforums.net:443/Threads/104652/Select-specific-Columns-in-Entity-Framework-using-Linq-query-in-ASPNet/https://www.aspforums.net:443/Threads/104652/Select-specific-Columns-in-Entity-Framework-using-Linq-query-in-ASPNet/Fri, 06 Jul 2018 00:13:52 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 GMTInsert Hindi, Marathi, Gujarati, Urdu, Persian, Arabic, Tamil and Telugu languages Text characters in Entity Framework using C# and VB.Net<p><em>When i type hindi text and save in sql server, then sql server shows ??? in place of hindi text nd when showing in grid, it also showing ?? in place of hindi text.</em></p>https://www.aspforums.net:443/Threads/630358/Insert-Hindi-Marathi-Gujarati-Urdu-Persian-Arabic-Tamil-and-Telugu-languages-Text-characters-in-Entity-Framework-using-C-and-VBNet/https://www.aspforums.net:443/Threads/630358/Insert-Hindi-Marathi-Gujarati-Urdu-Persian-Arabic-Tamil-and-Telugu-languages-Text-characters-in-Entity-Framework-using-C-and-VBNet/Wed, 07 Mar 2018 02:26:05 GMT