将分层的MS Access查询转换为.NET [英] Convert layered MS Access queries to .NET

问题描述

我正在尝试将某些MS Access查询转换为.NET.这些查询会调用其他查询，而其他查询又会调用其他查询，等等，有时最多达五个级别.由于要进行大量测试，因此我试图避免使用子查询，一些较低级别的查询用于多个较高级别的查询中，而某些较低级别的查询则引用了不同的数据源.

I am trying to convert some MS Access queries to .NET.  These queries call other queries that call other queries, etc., sometimes up to five levels deep.  I am trying to avoid using subqueries because of the amount of testing that would be required, some of the lower level queries are used in multiple high level queries, and some of the lower level queries reference different data sources.

是否可以使用数据表或某种其他方式来执行Access的工作?

Is there a way to use datatables or some other way to do what Access does?

推荐答案

仍然不确定您的意思是".Net".你是说SQL Server吗?如果是这样，请查看临时表(临时的结果存储在硬盘驱动器上)和表变量(临时的结果存储在内存中).您可以将查询结果插入其中之一，然后在以后的查询中使用该结果.

Still not sure what you mean by ".Net". Do you mean SQL Server? If so, look into temporary tables (temporary, results stored on hard drive) and table variables (temporary, results stored in memory). You can insert the result of a query into one of those, then use that result in a later query.

这篇关于将分层的MS Access查询转换为.NET的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！