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… SQl to LINQ with left join and GROUP 6 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 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… 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 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 to SQL windows form 15 Years Ago by songweaver … enter a last name to which it should do a LINQ to SQL query based on the last name in the database… Linq to SQL 13 Years Ago by syd919 …. I have just started learning silverlight and retrieving data through Linq to SQL. I have a problem with retrieving certain coulums from… Linq to SQL Connection String 13 Years Ago by syd919 … at all. I am designing a Silverligtht app with a Linq to SQL connection for the data. Here is my code.[CODE… Re: Linq to SQL Connection String 13 Years Ago by DavidKroukamp … at all. I am designing a Silverligtht app with a Linq to SQL connection for the data. Here is my code.[CODE… Re: Linq to SQL Connection String 13 Years Ago by syd919 Its a Multi-Tier app so I am connecting to the database using the Linq to SQL layer. Re: Linq to SQL Connection String 13 Years Ago by thines01 Would something like [URL="http://www.dotnetspark.com/kb/1969-linq-to-sql-silverlight-tutorial.aspx"]this tutorial[/URL] help? 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 to SQL Connection String 13 Years Ago by thines01 If you're trying to connect a SQL database to a Silverlight app, it's my understanding that can't be done. Am I off-base? What I've [I]heard[/I] is that you would need to call to WCF or Web Services to get the data. 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 :) 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. 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… 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 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… 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. Re: Linq to Sql - Retrieving the value of an identity column BEFORE inserting register 15 Years Ago by sknake … 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.[/QUOTE] No I read the OP's… 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 technology questions 14 Years Ago by bunbo900 ….net C#. This portion of the web application using technology LINQ to SQL and Ajax. This seems to be a simple change… Linq to SQL Connection String 13 Years Ago by syd919 … at all. I am designing a Silverligtht app with a Linq to SQL connection for the data. Here is my code.[CODE… SQL Connection from web.config 15 Years Ago by Ninjabear … System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web….WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class testDB : System.Web… Re: SQL Connection from web.config 15 Years Ago by vimalrasa … System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web….WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class testDB : System.Web… 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;… Re: SQL Connection from web.config 15 Years Ago by Ninjabear … sknake. I went into the service and set it to sql authentication instead but I couldn't log on with any… account (where is this account set?) I went into sql management studio and created an account but it doesn't… getting my setup to work. I've been into "sql management studio" > right click databases > attach >…