在.NET中查询DataSet / DataTable [英] Querying a DataSet/DataTable in .NET

问题描述

我认为如果我们可以在

客户端提供SQL引擎，那就太好了。我主要做Windows Forms编程，似乎我需要在线上进行大量的调用来操作数据以便显示

目的。

我是FoxPro的人，但我已经在.NET工作了1年。我们在FoxPro中使用了一个

应用程序命中SQL Server，我认为该系统很好地构建了b $ b。如果我有一个屏幕需要以某种方式显示数据

，这与数据的存储方式完全不同，我想b / b
认为应该生成信息客户端 - 因为它仅用于

显示（我可以把它放在业务对象中，这样我就可以在不同的客户端重用相同的

显示）。无论哪种方式 - 它都是一个显示项目。


我需要在SQL SP for .NET中执行此操作。我觉得把这个逻辑放在一个

SQL SP中，我将这个逻辑移到一个基于程序的智能数据库。我的b $ b有问题。这对我来说似乎并不高效。如果我转换我的数据库，那么我的业务逻辑很多都需要重写......


我们如何得到M $ ear来请求这个？我认为FoxPro在这个

主题上做对了...希望.NET会跟进。

I think it would be nice if we could have a SQL engine available on the
client side. I primarily do Windows Forms programming and it seems that I
have to make alot of calls accross the wire to manipulate data for display
purposes.

I am a FoxPro guy but I have been in .NET for 1 year now. We have an
application in FoxPro hitting SQL Server and I think that system is
architected well. If I have a screen that requires the data to be displayed
in a certain way that is completly different than how the data is stored, I
think that information should be generated client side - since it is a for
display only (I could put it in business objects so I can reuse the same
display in a different client). Either way - it is a display item.

I need to do this in a SQL SP for .NET. I feel by placing this logic in a
SQL SP, I am moving that logic to a ''procedural'' based smart database. I
have a problem with that. This just does not seem productive to me. If I
switch my database, alot of my business logic will need to be rewritten...

How do we get M$ ear to ask for this? I think FoxPro got it right on this
topic...hopefully .NET will follow.

推荐答案

耳朵要问为了这？我认为FoxPro在这个

主题上做对了...希望.NET能够遵循。

ear to ask for this? I think FoxPro got it right on this
topic...hopefully .NET will follow.

当开发一种非常具体的写入技术时类型的

应用程序，那么这可以完成。


..NET可以用来编程任何东西 - 视频游戏，数据库访问

程序等因此，提供适合每个人写作任何内容的功能真的变得更加困难。你可能需要这个功能，某人

其他可能真的需要别的东西等等。


Ty Salistean <泰********* @ discussions.microsoft.com>在消息中写道

news：57 ********************************** @ microsof t.com ...

When a technology is developed for writing very specific types of
applications, then this can be done.

..NET can be used to program anything - video games, database access
programs, etc. So it really becomes harder to provide features to accomodate
everyone who may be writing anything. You may need this feature, someone
else may really need something else, etc.

"Ty Salistean" <Ty*********@discussions.microsoft.com> wrote in message
news:57**********************************@microsof t.com...

我认为如果我们可以在客户端提供SQL引擎，那就太好了。我主要做Windows Forms编程，似乎我必须在线上进行大量的调用来操作数据以便显示


我是FoxPro的人但是我已经在.NET工作了一年了。我们在FoxPro中有一个
应用程序命中SQL Server，我认为该系统已经很好地构建了。如果我的屏幕要求以某种与数据存储方式完全不同的方式显示数据，那么我认为应该生成信息客户端 - 因为它只用于
显示（我可以把它放在业务对象中，所以我可以在不同的客户端重用相同的
显示）。无论哪种方式 - 它都是一个显示项目。

我需要在SQL SP for .NET中执行此操作。我觉得通过将这个逻辑放在一个SQL SP中，我将这个逻辑转移到一个基于程序的智能数据库。我有一个问题。这对我来说似乎并不高效。如果我切换我的数据库，我的业务逻辑很多都需要重写......

我们如何得到M

I think it would be nice if we could have a SQL engine available on the
client side. I primarily do Windows Forms programming and it seems that I
have to make alot of calls accross the wire to manipulate data for display
purposes.

I am a FoxPro guy but I have been in .NET for 1 year now. We have an
application in FoxPro hitting SQL Server and I think that system is
architected well. If I have a screen that requires the data to be
displayed
in a certain way that is completly different than how the data is stored,
I
think that information should be generated client side - since it is a for
display only (I could put it in business objects so I can reuse the same
display in a different client). Either way - it is a display item.

I need to do this in a SQL SP for .NET. I feel by placing this logic in a
SQL SP, I am moving that logic to a ''procedural'' based smart database. I
have a problem with that. This just does not seem productive to me. If I
switch my database, alot of my business logic will need to be rewritten...

How do we get M

ear to ask为了这？我认为FoxPro在这个主题上做对了...希望.NET能够遵循。

ear to ask for this? I think FoxPro got it right on this
topic...hopefully .NET will follow.

这篇关于在.NET中查询DataSet / DataTable的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！