ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2019 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>, 15 Jan 2018 00:37:39 GMTWhich is best to use in ASP.Net MVC ADO.Net or Entity Framework<p>Hi...</p> <p>i want fatch data from ERP database ,its having all lots stored procedure ,i want fatch data in MVC Application which database connectitvity&nbsp; is best ADO.NET OR Entity framework ???.</p> <p>&nbsp;</p> <p>Please provide your commands...</p> <p>&nbsp;</p> <p>Thanks &amp; Regards,</p> <p>VENKAT</p> <p>&nbsp;</p> <p>&nbsp;</p>, 17 Aug 2018 09:13:45 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>, 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>, 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>, 18 May 2018 01:12:37 GMTSimple User Registration Form with Entity Framework Database in ASP.Net MVC<p>Hi followed the step in ths example but am getting an error in UsersEntities and User , "could not be found".</p> <pre class="brush: csharp">public ActionResult UserRegister(User user) { UsersEntities usersEntities = new UsersEntities(); usersEntities.Users.Add(user); usersEntities.SaveChanges(); string message = string.Empty; switch (user.UserId) { case -1: message = &#34;Username already exists.\\nPlease choose a different username.&#34;; break; case -2: message = &#34;Supplied email address has already been used.&#34;; break; default: message = &#34;Registration successful.\\nUser Id: &#34; + user.UserId.ToString(); break; } ViewBag.Message = message; return View(user); }</pre> <p>&nbsp;</p>, 07 Mar 2019 05:33:50 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>, 06 Jul 2018 00:13:52 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>, 13 Nov 2017 06:44:51 GMTUsing Stored Procedure with Entity Framework in ASP.Net MVC<p>How to use a stored procedure in MVC project with Entity framework</p> <p>&nbsp;</p> <p>Thanks</p> <p>R</p>, 27 Nov 2018 05:45:39 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>, 24 Jun 2016 02:25:03 GMTUsing Lambda expression instead of For Each Loop in ASP.Net<p>I have used for each loop and counter, I got code review comment like "please use a lamba expression here, to isolate an occurrence, as opposed to iterating over all and then doing something in response to all found "</p> <p>Please help how to use lamda expresion here. Thanks.</p> <pre class="brush: vb">Private Function DiamondScoreCheckForOdType(ByVal currentPolicyLob As String, ByVal predominantState As String, ByVal policyEffectiveDate As Date) As Boolean Dim listOfLobForDiamondScoreRule As New HashSet(Of String) From {{getLineOfBusiness(Lob.LineOfBusiness.Auto)}, {getLineOfBusiness(AutoNonDealer)}, {getLineOfBusiness(Lob.LineOfBusiness.Garage)}, {getLineOfBusiness(EmploymentPracticesLiability_EP)}, {getLineOfBusiness(GeneralLiability)}, {getLineOfBusiness(InlandMarine)}, {getLineOfBusiness(PesticideHerbicide)}, {getLineOfBusiness([Property])}, {getLineOfBusiness(Umbrella)}} Dim lobList As New List(Of String) Dim eligibleLobCheckCounter As Integer = 0 lobList = currentPolicyLob.Split(ASTERISK).ToList() For Each currentLob In lobList listOfLobForDiamondScoreRule.Contains(currentLob) If (listOfLobForDiamondScoreRule.Contains(currentLob)) Then eligibleLobCheckCounter = eligibleLobCheckCounter + 1 End If Next If (eligibleLobCheckCounter &gt; 0) Then Dim isStateAndEffDateEligible As Boolean = (New LobCO.Shared.COShared).IsStateRuleApplicable(getLineOfBusiness(Lob.LineOfBusiness.Common), predominantState, policyEffectiveDate, DiamondScoreRuleCheckForOdType) Return isStateAndEffDateEligible End If Return False End Function</pre> <p>&nbsp;</p>, 07 Sep 2018 01:52:46 GMTSelect record having age between 18 and 21 using Linq query in Entity Framework<p>i m finding user according to age, but in database i have only date of birth, my dob in database is date type.stores values like&nbsp;1990-08-22,</p> <p>in need to find users from age 18 to age 25</p>, 07 Aug 2018 00:50:14 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>, 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>, 13 Mar 2013 00:34:27 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>, 07 Aug 2015 09:26:31 GMTUnable to add Namespace using Entity Framework in ASP.Net<p>I'm follow your code(<a href="">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="">files link</a>)</p>, 03 Dec 2017 01:05:54 GMTSelect record from database with Join and where conditions using Linq query in ASP.Net<p>userlist1 showing all user values, but userlist2 not showing value.</p> <p>Can i apply condition where direct to userlist1 how?</p> <pre class="brush: csharp">string dob2 = dobyear2 + &#34;-&#34; + month + &#34;-&#34; + 1; DateTime dob22 = Convert.ToDateTime(dob2); List&lt;User_Detail&gt; userlist = new List&lt;User_Detail&gt;(); // userlist = db.User_Detail.Where(s =&gt; s.Gender == 2 &amp;&amp; s.DOB &lt;= dob21 &amp;&amp; s.DOB &gt;= dob22).ToList(); var userlist1 = (from u in db.User_Detail &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; join st in db.State_Name on u.State equals st.State_Id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; join h in db.Height_Table on u.Height equals h.Height_Id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; join e in db.Education_Qualification on u.Education_Qualification equals e.Education_Id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; join leng in db.Mother_Tongue on u.Mother_Tongue equals leng.Language_id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; join rlgn in db.Religions on u.Religion equals rlgn.Religion_Id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; join cast in db.Castes on u.Caste equals cast.Caste_Id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; join incm in db.AnnuaIncome_Table on u.Annual_Income equals incm.Income_Id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select new users_details &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; First_Name = u.First_Name, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Last_Name = u.Last_Name, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Annual_IncomeName = incm.Annual_Income, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Caste1 = cast.Caste1, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Religion_Name = rlgn.Religion_Name, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Language = leng.Language, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EducationName = e.Education, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; StateName = st.State &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }).ToList(); var userlist2 = userlist1.Where(s =&gt; s.Gender == 2 &amp;&amp; s.DOB &lt;= dob21 &amp;&amp; s.DOB &gt;= dob22).ToList(); </pre> <p>&nbsp;</p> <p>&nbsp;</p>, 10 Aug 2018 06:13:54 GMTSave binary image in Database using Entity Framework in ASP.Net<p>I want to save image into database using entity framework without mvc.</p> <p>I have tried bt it wont worked. Plz Help me out from this problem.</p> <p>Below I have attached file which i have tried</p> <p>.aspx code</p> <pre class="brush: html">&lt;div style=&#34;float:left&#34;&gt; &lt;table&gt; &lt;tr &gt; &lt;td style=&#34;padding-left:5px&#34;&gt; &lt;div style=&#34;float:left&#34;&gt; &lt;asp:Image ID=&#34;Image1&#34; ImageUrl=&#34;http://localhost:9002/Images/pup.jpg&#34; runat=&#34;server&#34; class=&#34;img-circle&#34; /&gt; &lt;/div&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/div&gt; &lt;div style=&#34;float:none&#34;&gt; &lt;asp:Label ID=&#34;lblAllow&#34; runat=&#34;server&#34; Text=&#34;Allowed file types: TIF, PNG, JPG&#34; &gt;&lt;/asp:Label&gt;&lt;br /&gt; &lt;asp:FileUpload ID=&#34;FileUpload1&#34; runat=&#34;server&#34; UploadedFilesRendering=&#34;BelowFileInput&#34;/&gt;&lt;br /&gt;&lt;br /&gt; &lt;div style=&#34;text-align:center&#34;&gt; &lt;Telerik:RadButton ID=&#34;RadBtnUpload&#34; runat=&#34;server&#34; Text=&#34;Upload Selected&#34; skin=&#34;Windows7&#34; style=&#34;align-self:center&#34; OnClick=&#34;RadBtnUpload_Click&#34;&gt; &lt;Icon PrimaryIconCssClass=&#34;RadBtnUpload&#34; /&gt; &lt;/Telerik:RadButton&gt; &lt;/div&gt; &lt;asp:RegularExpressionValidator ID=&#34;RegularExpressionValidator3&#34; ValidationExpression=&#34;([a-zA-Z0-9\s_\\.\-:])+(.png|.PNG|.jpg|.JPG|.tif|.TIF)$&#34; ControlToValidate=&#34;FileUpload1&#34; runat=&#34;server&#34; ForeColor=&#34;Red&#34; ErrorMessage=&#34;Only JPG, PNG, TIF allowded.&#34; ShowMessageBox=&#34;true&#34; Display=&#34;Dynamic&#34; /&gt; &lt;/div&gt; &lt;/div&gt;</pre> <p>.asp.cs code</p> <pre class="brush: csharp"> protected void RadBtnUpload_Click(object sender, EventArgs e) { string folderPath = Server.MapPath(&#34;~/Forms/Uploads/&#34;); if (!Directory.Exists(folderPath)) { Directory.CreateDirectory(folderPath); } FileUpload1.SaveAs(folderPath + Path.GetFileName(FileUpload1.FileName)); Image1.ImageUrl = &#34;~/Forms/Uploads/&#34; + Path.GetFileName(FileUpload1.FileName); EmployeePortal.Models.NCI.NCIEntities ent = EmployeePortal.Models.ClsNCIUtil.GetNCIEntity(Session[&#34;CustomerID&#34;].ToString()); using (ent) { EmployeePortal.Models.NCI.EmployeeImage eimg = ent.EmployeeImages.FirstOrDefault(a =&gt; a.EmployeeId == empno);//&amp;&amp; a.CustomerId == customerId); if (FileUpload1.HasFile) { var img= (from a in ent.EmployeeImages where a.EmployeeId == empno select a.EmpImage); byte[] FileUpload1 = eimg.EmpImage; ent.SaveChanges(); } } </pre> <p>plz help me.... </p> <pre class="brush: sql">CREATE TABLE [dbo].[EmployeeImage]( [SrNo] [int] IDENTITY(1,1) NOT NULL, [EmployeeId] [int] NULL, [CustomerId] [int] NULL, [EmpImage] [image] NULL, [LastModifiedDate] [datetime] NULL, [LastModifiedUser] [nvarchar](25) NULL, [LastModifiedDescription] [varchar](200) NULL, CONSTRAINT [PK_EmployeeImage] PRIMARY KEY CLUSTERED ( [SrNo] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]</pre> <p>&nbsp;</p>, 27 Sep 2018 01:24:30 GMTRead SQL Server table and write to SQLite using Entity Framework in ASP.Net<p>Hi,</p> <p>i have to&nbsp; create an application for sales force to collect orders.</p> <p>I need some tables of company (customers, products...ecc).</p> <p>I need to read the tables above from sql server database and write to SQLite database.</p> <p>How can i solve this task? I never do that.</p> <p>I would use&nbsp; simple form application wit Entity Framework to serialize and write.</p> <p>I need some sample to start (video,link...)</p> <p>tks to everybody</p>, 08 Oct 2018 00:26:09 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, }).ToList();<br /> Cbox.DataSource = query.ToList();</p>, 09 Mar 2013 07:21:53 GMT