entity-sql

相关标签：javascript jquery android 多少钱 iPhone

Entity SQL query with hierarchal relation

I want to use Entity SQL to query the elements of some subtype in my Entity Model. For instance... SELECT VALUE c FROM Persons AS c[详细]

2023-01-13 21:24 分类：问答
Comparing DateTime in Entity Framework with an Sql Server Compact database

Why this code throws a System.NotSupportedExceptio开发者_如何学编程n telling that The specified method \'int? DateDiff(string, DateTime?, DateTime?)\' on the type \'System.Data.Objects.SqlClient.SqlFu[详细]

2023-01-05 11:43 分类：问答
How to implement EntityDataSource Where IN entity sql clause

I want to pass a number of values into a parameter of the EntityDataSource, e.g.: Where=\"it.ORDER_ID IN {@OrderIdList}\" (this is a property on the EntityDataSource)[详细]

2022-12-29 07:51 分类：问答
How should I use navigation properties while writing a query using eSQL?

I am trying to write a query using e开发者_Go百科SQL wherein my entity has got navigation properties. I am not able to include these navigation properties in the query, even though in Linq to SQL we h[详细]

2022-12-28 05:21 分类：问答
Is writing eSQL database independent or not?

Using EF we can use LINQ to read data which is rather simple (especially using fluent calls), but we have less control unless we write eSQL o开发者_StackOverflown our own.[详细]

2022-12-26 02:15 分类：问答
Entity Sql Group By problem, please help

help me please with this simple E-sql query: var qStr = \"SELECT SqlServer.Month(o.DatePaid) as month, SqlServer.Sum(o.PaidMoney) as PaidMoney FROM XACCModel.OrdersIncomes as o group by SqlServer.Mo[详细]

2022-12-25 08:49 分类：问答
Entity framework (3.5): How to translate a certain LINQ query to eSQL?

I have the following LINQ query that I need to translate to Entity SQL /eSQL): return (ObjectQuery<User>) from user in Users[详细]

2022-12-23 08:49 分类：问答
How to map EntitySql function to a differently named function in the store?

The question is: Given a database backend that understands LeftStr and RightStr: where, in a custom ADO.NET provider implementation, would I establish a mapping to the immutable EDM canonical function[详细]

2022-12-16 10:58 分类：问答