Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
如何使用SQL语法?
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  2 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
LumberW@gmail.com  
View profile   Translate to Translated (View Original)
 More options Dec 8 2006, 6:09 am
From: "Lumb...@gmail.com" <Lumb...@gmail.com>
Date: Fri, 08 Dec 2006 03:09:34 -0800
Local: Fri, Dec 8 2006 6:09 am
Subject: 如何使用SQL语法?
gateway.FindArray<...>()默认的是"SELECT * FROM
Table",请问如何可以只选择某几个字段,而不是选取全部字段,不要说用gateway.Db里的方法。
还有,SQL语句中的一些关键字如何实现,比如TOP、in、between、Distinct等等,Entityspace里这些方面就实现得很好

    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Teddy  
View profile   Translate to Translated (View Original)
 More options Dec 8 2006, 8:03 am
From: Teddy <shijie...@gmail.com>
Date: Fri, 8 Dec 2006 21:03:19 +0800
Local: Fri, Dec 8 2006 8:03 am
Subject: Re: 如何使用SQL语法?

1、只选择某几个字段目前必须定义包含需要的列的专门的只读(标注ReadOnly)设计实体。

2、只需要使用Gateway.GetPageSelector().GetPage(1)方法独取第一页就是使用TOP语法查询的。

3、聚合查询Gateway.Count是支持Distinct的。

4、最新的v3.3.9版已经增加In和Between查询支持了。可以类似User._.Price.Between(1000,
5000)和User._.ID.In(1, 3, 5, 6, 10)这样的语法进行查询。

可以从这里下载v3.3.9:http://www.codeplex.com/nbear/Release/ProjectReleases.aspx

Teddy

On 12/8/06, Lumb...@gmail.com <Lumb...@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google