Search DaniWeb - linq-sql

LINQ SQL DateTime Error 13 Years Ago by Skeldave ….InsertOnSubmit(journey); db.SubmitChanges(); OutboundFlight is set as DateTime in SQL Server 2005 and I am using Visual Studio 2010 If… LINQ query \ LAMBDA expression - complex requirement 16 Years Ago by sumitshah4u … 10 SELL I want this datatable to be processed by LINQ / LAMBDA expressions in such a way that will give me… 10 BUY Can anybody please help me in writing a LINQ query \ LAMBDA expression for the above case. Thanks in advance… Re: LINQ query \ LAMBDA expression - complex requirement 16 Years Ago by sumitshah4u Lets say for simplicity, we remove the price column and do not require it. Can you please provide the LINQ query \ LAMBDA expression for this updated requirement. Re: LINQ query \ LAMBDA expression - complex requirement 16 Years Ago by sumitshah4u Unfortunately, i am tqtally new to LINQ /Lambda. Can you please help me write a expression for it. I will really be thankful to you. Thx :) LINQ to SQL Oddities 11 Years Ago by Begginnerdev … which is using VB.NET for code behind. We use LINQ to SQL and classed object for the data retreival. I have… is 'deleted'. Here is the odd thing: When checking from SQL Server, the deleted row is still in the database BUT… SQL query: foreach row? 14 Years Ago by MaryAnne19 ….ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.…= string.Format("DataSource=\"{0}\";", fileName); // SQL Command string sql = "select * from PeopleTable"; SqlCeConnection cn = null;… Linq to sql 13 Years Ago by Twistar … in a drop down list which is populated from my sql database table tblGrupper. I have managed to populate a GridView… Re: Group by query in linq 10 Years Ago by pritaeas What do you need? A SQL query or LINQ? SQL would be something like this: SELECT P.ProductName, O.CustomerId, SUM(P.Quantity) FROM Product P, Order O WHERE P.OrderId = O.OrderId GROUP BY P.ProductName, O.CustomerId [LINQ, C#]Problem with autogenerated DataClasses.designer.cs 16 Years Ago by szmitek … have problem with LINQ. I have created SQL Server 2005 database…public DataClassesDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) : Line 65: base…239: { Line 240: throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException(); Line 241: } Line 242: this.… SQl to LINQ with left join and GROUP 5 Years Ago by Rushabh Verma I created a worked sql query: select CONVERT(date, C.tDate) as dt, count(O.…(date, C.tDate) And I want to rewrite it use LINQ: var res = (from c in db.Calendars join o in… get all rows from calendar in sql query, but only not null rows (right part) in LINQ query. How can I get… LINQ and MariaDB 11 Years Ago by JDoggieIII …and previously accessed the database (mostly inserts) with LINQ. When I attempt to insert (other transactions have… "You have an error in your SQL syntax; check the manual that corresponds to your…setup the same as it was in MS SQL. Any thoughts on this subject would be …go back and remove all use of LINQ and write SQL by hand, but if I can get… Linq to SQL 13 Years Ago by syd919 …, I hope you are all doing fine. I have a Linq to SQL problem. My entity class is as follows; [CODE]using… System; using System.Data.Linq; using System.Data.Linq.Mapping; namespace SilverlightGrid.Web… LINQ Error when grouping 10 Years Ago by lithium112 … advice. I am having to convert a SQL stored proceedure over to LINQ. The SQL statement is structured like below: SELECT SUM((Amt… LINQ to SQL 14 Years Ago by chickod …'t think so). I have added a .dbml (LINQ to SQL) file to my project and I am about to …button, you have a choice which includes "Microsoft Sql Server Database (Sql Client)." This choice does NOT appear - instead, …I am forced to use "Microsoft Sql Server Database [COLOR="Red"]File[/COLOR]," which… Re: LINQ Question 16 Years Ago by sedgey Scott Gu's blog has a great article on linq to sql which includes examples of executing stored procs. [URL=&…http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx"…http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx[/URL] Re: LINQ to SQL; query/command syntax NEWBIE 14 Years Ago by pritaeas What helped me getting started with linq was LinqPad. It allows you to write and convert queries and execute them against your database. You can write sql, the app will convert it to linq. Nice way of getting used to it. SQL Join Query to LINQ Query 13 Years Ago by neo.mn Hi everyone, I am new in LINQ. Please let me help to convert the following SQL Query into LINQ query. The Query is : [CODE… Re: SQL Join Query to LINQ Query 13 Years Ago by thines01 [If you have an option] I would not suggest converting this to Linq-to-SQL if you are new to Linq. If this is for class, I want to be in that class because it's cool! Re: LINQ and MariaDB 11 Years Ago by JDoggieIII Yes, the connection is set to MySQL, but linq continues to spit out incorrect SQL ([ and ] rather than ' or "). Is there a settings I'm perhaps missing somewhere? LINQ QUERIES 11 Years Ago by hussain_ahmed …using System.Web.UI.WebControls; using System.Data.Linq.Mapping; public partial class Default3 : System.Web.…} protected void Button6_Click(object sender, EventArgs e) { //Linq to SQL DataClassesDataContext dc = new DataClassesDataContext(); var biofee = from bio … LINQ insert method problem, .NET 3.5, VS2008, LINQ 16 Years Ago by andrewgxx … correct values. I call the LINQ method "InsertProject" to insert the data into the SQL tables. The error message I… Re: Linq to SQL 13 Years Ago by thines01 Can you convert the Table<Travel_MealDetails> to a List<Travel_MealDetails> before running the Linq? Also (after that), your linq can just return a List<Travel_MealDetails> [CODE] return (from c in lst_meals select new ... ).ToList(); [/CODE] ...you won't need to call .ToList() twice. LINQ in a WCF Service 15 Years Ago by swinefish … I've built, and it's with LINQ. Having written the service, which uses LINQ to SQL classes, I am now trying to… LINQ to SQL; query/command syntax NEWBIE 14 Years Ago by JimOneill … just trying to get a piece of data from a SQL database and store it in a variable. From various book… cobbled together the mess below. What I'm attempting (using LINQ to SQL) is to get a value from the "Password… LINQ bool value equal to null 14 Years Ago by jammiedude … about ready to shut up shop! So im looking at LINQ to try and pull off records where a confirmed field…. The confirmed field is a bool value (or bit in SQL) so when i insert the record im putting this value… tried another couple of ways but i still cannot get LINQ to translate properly.... Yes i could just add another field… LINQ in visual studio 2008 C# 14 Years Ago by judithSampathwa hi there, i have a question in LINQ in C#, i have a webpage and in that i … a button called clicl and theGridview . i have a LINQ to SQL class with the Employee and the USErLogin which the EID… Re: LINQ in a WCF Service 15 Years Ago by kvprajapati ….msdn.com/aconrad/archive/2007/12/10/linq-to-rest.aspx"]Linq to REST[/URL] [URL="http…library supports constructing queries against remote data services using LINQ. In essence the library provides a strongly typed …query experience via LINQ, where each LINQ query is translated by the library to HTTP… Re: SQL Connection from web.config 15 Years Ago by Ninjabear …the "server authentication" method to "sql server and windows authentiation mode". Set "…quot;new login". [U]General[/U] Select SQL Server Authentication Uncheck "Enforce password policy". …;. Set the authentication method to "use sql server authentication" and enter the username and… Linq to Sql - Retrieving the value of an identity column BEFORE inserting register 15 Years Ago by josi.martarelli …]SELECT IDENT_CURRENT ('alpa_Animais') AS AnimalID[/CODE]" directly using the SQL Server Management Studio I get this value. Does anyone know… this value from a method inside a web app using Linq? Thank you Josi Re: Linq to Sql - Retrieving the value of an identity column BEFORE inserting register 15 Years Ago by kvprajapati … identity column before insert a row into a table. [code=sql] SELECT IDENT_CURRENT ('tablename') [/code] will retrieve latest value of an… this value from a method inside a web app using Linq? -- answer is Yes.