Lab Sql

I wonder if anyone else has asked a similar question. Basically, I have a huge tree I'm buildin… Read more How Can I Get A Percentage Of Linq To Sql Submitchanges?

This is a follow-up to this question. TLDR: The question: I want to filter a query to only keep th… Read more Efficient Query For Only The First N Rows For Each Unique Id

I've this query below working fine. However I want to implement it using Linq. select u.ID, u.N… Read more Linq To Sql - Having And Group By

I'm working on a business app that requires that ALL database transactions be audited (for lega… Read more Linq To Sql Audit Trail / Audit Log: Should I Use Triggers Or Doddleaudit?

Good day! I have used LINQ2SQL with SQL Server 2005, but now I need to use it with SQL Server 2000.… Read more Linq2sql And Sql Server 2000

title speaks for itself, db.ExecuteCommand('INSERT INTO tCSVFile(fileName, fileContent, mimetyp… Read more Linq To Sql Insert Not Working On Deployed Server(iis)

Normally, when you want to call a stored procedure directly through Linq to Sql, you can use the Ex… Read more Is It Possible To Use Output Parameters With Executequery?

I want to have the following query in Dynamic LINQ.. I have tried some solutions but have not succe… Read more Dynamic Linq Syntax For Subquery

For some reason I'm having a hard time wrapping my mind around how to do this. I have a table o… Read more Linq To Sql - Self Join Child To Parent (same Table)

I'm using LINQ, but my database tables do not have an IDENTITY column (although they are using … Read more Linq Inserts Without Identity Column

I've recently started to work with Linq to SQL and wondered how to get multiple rows as a resul… Read more How To Retrieve Multiple Rows From A Stored Procedure With Linq To Sql?

I am trying to convert the following stored proc to a LinqToSql call (this is a simplified version … Read more How To Have A Where Clause On An Insert Or An Update In Linq To Sql?

I am running into a road block on a larger problem. As part of a large query I need to solve a '… Read more Checking For Time Range Overlap, The Watchman Problem [sql]

What do I need to add, if I need to at all, to avoid sql injections? public static Login GetLoginBy… Read more Linq To Sql And Sql Injection

The following query against a SQL Server 2012 database, using Entity Framework Core 3.1: va… Read more Why Does Linq Generated Sql Include Multiple "is Null" Conditions For The Same Column

I'm trying to make a function that changes the query result value to the values in a textbox. I… Read more Property Or Indexer 'anonymoustype#1.firstname' Cannot Be Assigned To -- It Is Read Only

So, if I use this query directly or by using db.ExecuteCommand() , everything will work fine; updat… Read more Using Linq To Sql To Perform An Update/set

On SQL 2005 I have a simple SP that selects rows from a table. The SP does not use temporary tables… Read more Linq To Sql - Stored Procedure Return Type Error

I have a small problem which I need a help to solve: I have following situation: For example: I wan… Read more Ef 6 Select From Other Table Without Navigation Property

Hi guys I have this SQL query (MSSQL), I'm doing a query where the result of joins are giving m… Read more Linq Translation Doesn't Give The Same Results As My Sql Query