SqlDbType.Structured是什么意思? [英] What does SqlDbType.Structured mean?

问题描述

从msdn 网站我得到以下信息:

From msdn website I get the following:

一种特殊的数据类型，用于指定表值参数中包含的结构化数据.

A special data type for specifying structured data contained in table-valued parameters.

似乎我的代码可以使用它，也可以不使用它(使用存储过程将表推入数据库).

It seems my code works with it and without it (pushing table to DB using stored procedure).

有人可以解释它的作用-我从定义中无法理解它.

Can someone explain what does it do - I didn't understand it from the definition.

推荐答案

在SQL Server中，您可以定义存储过程，还可以将表作为参数传递.这就是所谓的表值参数.

In SQL Server, you can define stored procedures and you can pass tables as parameter. This is then called a table valued parameter.

使用C#编程时，可以使用SqlDbType.Structured常量将这种表值参数传递给数据库.

When you are programming in C#, you can pass such a table-valued parameter to the database by using the SqlDbType.Structured constant.

本文显示了一个示例:如何传递表值参数

This post shows an example: How to pass a table-value parameter

这篇关于SqlDbType.Structured是什么意思?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！