zzz projects Entity Framework 6 EF 6
Home EF Core 5 Articles Knowledge Base Online Examples
  • Home
  • EF Core 5
  • Articles
  • Knowledge Base
  • Online Examples

Entity Framework 6 - Knowledge Base (KB)

English (en) Français (fr) Español (es) Italiano (it) Deutsch (de) русский (ru) 한국어 (ko) 日本語 (ja) 中文简体 (zh-CN) 中文繁體 (zh-TW)

274 results for: in tag: sql

Optimize Group By in LINQ to Entities

I have this query in LINQ to Entities.... var query = (from s in db.ForumStatsSet where s.LogDate >= date1 && s.LogDate <= date2 group s by new { s.Topic.topicID, s.Topic.subject, s.Topic.Forum.forumName, s...
entity-framework linq linq-to-entities sql
asked by Olaj

Adding to the Where clause of an Update in LinQ-to-Entities

Let's say I have a table called Product, with three columns: Id, CustomerId, Name. Id is the primary key. The schema is outside of the control of my group, and we now have a requirement to always provide CustomerId as a parameter for all queries (selects...
entity-framework linq linq-to-entities sql
asked by Joel Martinez

Join and Include in Entity Framework

I have the following query of linq to entities. The problem is that it doesn't seem to load the "Tags" relation even though i have included a thing for it. It works fine if i do not join on tags but i need to do that.... var items = from i in d...
.net c# entity-framework linq sql
asked by Olaj

What is datetime2?

I´ve got this in a INSERT statment to MSSQL 2008...System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.
.net c#-3.0 entity-framework sql sql-server-2008
asked by Glenn

Performing Insert OR Update (upsert) on sql server compact edition

I have c# project that is using sqlserver compact edition and entity framework for data access. I have the need to insert or update a large amount of rows, 5000+ or more to the db, so if the key exists update the record if not insert it. I can not find ...
c# entity-framework sql sql-server-ce upsert
asked by RBear

Is it possible to run native sql with entity framework?

I am trying to search an XML field within a table, This is not supported with EF....Without using pure Ado.net is possible to have native SQL support with EF?
ado.net entity-framework sql
asked by user80855

SQL Server Compact Edition with Entity Framework

I try to use SQL Server Compact Edition with Entity Framework in Visual Studio 2008 SP1. Here's what I do:...1) I create a new project, of type Console Application....2) I right-click on the project, select Add->New Item....3) I choose to add a Local Data...
c# entity-framework sql sql-server-ce
asked by Nitramk

Zend Framework SQL update query

How would I write this SQL the Zend Framework way?...UPDATE register SET balance = (balance + 10) WHERE added_date > 1259944184 ; ...I can't find any examples of this on Zend's website or the web....Do I need to use "...Zend_Db_Expr..."?
entity-framework sql sql-update zend-framework
asked by EricP

EntityFramework Procedure or function '' expects parameter '', which was not supplied

I apologise for asking just a basic question, however I cannot find the cause of this error....I am using Entity Framework to execute a Stored Procedure, and I am passing in four parameters, however the SQL Database seems to reject them. Can anyone point ...
c# entity-framework sql
asked by James

Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures?

How would you rate each of them in terms of:...Performance...Speed of development...Neat, intuitive, maintainable code...Flexibility...Overall...I like my SQL and so have always been a die-hard fan of ADO.NET and stored procedures but I recently had a pla...
ado.net entity-framework linq-to-entities linq-to-sql sql
asked by BritishDeveloper

Best pattern for storing (product) attributes in SQL Server

We are starting a new project where we need to store product and many product attributes in a database. The technology stack is MS SQL 2008 and Entity Framework 4.0 / LINQ for data access....The products (and Products Table) are pretty straightforward (a...
database database-design entity-framework sql sql-server
asked by EdH

Limiting query size with entity framework

this is a simple question (I think), but I have not been able to find a solution. I know with other types of queries, you can add a limit clause that makes the query only return up to that many results. Is this possible with an entity query?...var product...
c# entity-framework sql
asked by PFranchise

LINQ to Entities - Where IN clause in query

Possible Duplicates:...Linq to Entities - Sql “IN” clause...How to implement SQL “in” in Entity framework 4.0...how can I add WHERE IN statement like......SELECT * FROM myTable WHERE ID IN (1,2,3,4,5) ...in entity framework
c# entity-framework sql
asked by Muhammad Akhtar

Entity Framework: How to properly handle exceptions that occur due to SQL constraints

I use Entity Framework to access my SQL data. I have some constraints in the database schema and I wonder how to handle exceptions that are caused by these constraints....As example, I get the following exception in a case where two users try to add an (a...
constraints entity-framework sql sql-server unique-constraint
asked by driAn

SQL Profiler not showing inserts/deletes/updates

When I run the profiler while running my application, it only seems to show SELECTs, not INSERTs or anything that changes the database. Yet my database is being updated, so those commands must be being executed. What do I have to do to get it to show upda...
entity-framework sql sqlprofiler sql-server-2005
asked by Cynthia

Entity Framework Connection String Trouble

I am making a little library(DLL) to manage users and their roles/privileges. The plan is to be able to add this dll to an MVC project and be able to manipulate users/roles/etc. All the data resides in a SQL db....I am using entity framework for data ac...
c# entity-framework sql
asked by Jason

How to quickly refresh ADO.NET Entity Data Model?

I am using ADO.NET Entity Data Model in my C# project. There is an ADO.NET Entity Data Model that is generated on the DB in my project. How do I quickly refresh the ADO.NET Entity Data Model based on DB changes? I have been deleting the model and then cre...
ado.net c# entity-framework sql
asked by Anton

Windows form application exception

I get application exception... at System.Windows.Forms.CurrencyManager.get_Item(Int32 index) at System.Windows.Forms.CurrencyManager.get_Current() at System.Windows.Forms.DataGridView.DataGridViewDataConnection.OnRowEnter(DataGridViewCellEventArgs...
c# datagridview entity-framework sql winforms
asked by Anton

asp mvc get last insert id from savechanges()

im using poco code first . how do i get the last insert after savechanges() ?...thanks
asp.net asp.net-mvc-3 entity-framework linq sql
asked by colorblack04

Concurrent access to a database with Entity Framework == EntityException

I've a MS SQL 2008 database which is accessed through LINQ for data update/retrival....My linq is accessed by WCF services in a PerCall instantiation mode for an heavy application. This application has several thread which makes calls to the service, and ...
concurrency entity-framework multithreading sql wcf
asked by J4N

Page 1 of 14
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • …
  • »
  • »»

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

Try for free now