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...
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...
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...
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.
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 ...
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?
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...
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..."?
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 ...
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...
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...
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...
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
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...
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...
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...
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...
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...
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 ...