从访问转换为sql [英] converting from access to sql

问题描述

在访问中，

in access,

OleDbConnection con=new OleDbCollection();
con.Open();
DataTable schTable=con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
					new Object[] { null, null, null, "TABLE" });

如何为sql编写类似的代码？

how can write similar code for sql?

推荐答案

本网站上有一些文章介绍了如何从SQL Server中获取数据库模式C＃。我尝试嵌入一个链接，但页面一直在冻结，所以你需要查找它。



代码必须解决数据库架构，总是让我紧张我没想到连接到你不知道架构的数据库的理由。

There are articles on this site that show how to get a DB schema from SQL Server in C#. I tried embedding a link, but the page kept freezing, so you'll need to look for it.

Code that has to work out the DB schema, always makes me nervous. I cna't think of a good reason to connect to a DB you don't know the schema for.

这篇关于从访问转换为sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！