Lab Sql

For background info, I'm running .NET core on Arch Linux VScode and I also have SQL Server runn… Read more Getting An Sql Connection String Error When Scaffolding In Ef Core?

I have the following EF Code First classes, which appear to be working to a point. I also have Ini… Read more Reinstantiating Ef Classes With One-to-many Relationship And Compound Key Of Strings

I'm having an issue updating a 'bit' column in a SQL database, using C# and Entity Fram… Read more Updating Sql Bit Column From Entity Framework

I have just started using EF and found it cool, but I ran into a problem, Problem: I changed my DB … Read more Updating Entity Framework Model

in my c# code I have an insert into my DB, but it throws an exception Cannot insert the value NUL… Read more Cannot Insert The Value Null Into Column ... When The Value Is Not Null

I wonder, if there is any way , to use Database-first approach with manually generated classes (mod… Read more Database-first Approach In Entity Framework Without Auto Generated Code

PROBLEM: I am trying to create a EF6 model using the database first approach. Simply speaking, I ha… Read more Ef6 Does Not Generate Foreign Key Association From Database

From the documentation: Entity Framework Core will automatically fix-up navigation properties to a… Read more Ef Core Fix-up When Querying Subset Of Columns

I would like to know what is the best practice to work with C# and SQL Server (entity framework) be… Read more Entity Framework Long Living Data Context Vs Short Living Data Context

I am trying validate values to be inserted into SQL from Web API 2 and Repository Pattern. The dat… Read more How To Return Values To Web Api Controller From A Stored Procedure In Dbcontext

So I believe I have found out that group join is a left outer join and that is what I need. But I n… Read more Linq Group Join And Where Statement On Property Of The Joined Table

I have this table in my database and I want to store incoming data: public string Id { get; set; } … Read more How To Store List In Sql Server From Asp.net Core?

I am querying a tinyint column and entity-framework generates a SELECT query that introduces a CAST… Read more Generated Query For Tinyint Column Introduces A Cast To Int

I've been getting this error when I try and use my model container: No connection string named… Read more Entity Sqlce Can't Find Connection String In App.config File

I want to create some test cases for Entity Framework queries that surely generate SQL commands tha… Read more Entity Framework And Cross/outer Apply

Using Entity Framework 5 is it possible to use a stored proc with optional parameters such that you… Read more Entity Framework With Optional Parameters?

i am storing Leave Information of an employee in database.From and To Date will be stored in DB.I w… Read more Check One Date Is Falling Between Date Range-linq Query

NOTE: This issue has been resolved, but lead to a new question. I'm getting this error: Syste… Read more .net Sql New Table Doesn't Exist

SQL returns codes that are preceded by a minus sign (-) indicate that the SQL statement execution w… Read more Is It Possible To Retrieve Sql Error Codes From Unsuccessful Entity Framework Data Operations?

Working on getting a stored procedure to execute from a web app. I can verify that the values are b… Read more Entity Framework Code First Stored Proc Incorrect Syntax / Must Declare Scalar Varible