我有一节课要点：
class Point
{
public int X { get; set; }
public int Y { get; set; }
public double Value { get; set; }
}
以及汇总cca 1000分的等级表。
[Table(Name = "Chart")]
class Chart
{
public List<Point> Points { get; set; }
}
我想有效地将积分保存到数据库中。我不需要在积分之上做任何运算。有没有办法将点保存在一列中？我认为这种方式应该比创建1000000点的新表更有效。Thx公司
查找SqlBulkCopy-它不是Linq，但它允许您比Linq更快地将大量数据推送到SQL Server中。
我建议使用一张桌子。1000000行两个int，一个double和一个FK将是非常有效的。如果您担心数据进出数据库，那么可能需要对这些数据执行linq-to-sql以外的操作
也就是说您可以使用XML键入列并将您的点存储在其中，这是Linq to sql所支持的。但也需要考虑其他一些因素。
The SQL Server XML data type is available starting in Microsoft SQL Server 2005. You can map the SQL Server XML data type to XElement, XDocument, or String. If the column stores XML fragments that cannot be read into XElement, the column must be mapped to String to avoid run-time errors. XML fragments that must be mapped to String include the following:
XML元素的序列
属性
公共标识符（PI）
评论
Although you can map XElement and XDocument to SQL Server as shown in the Type Mapping Run Time Behavior Matrix, the DataContext.CreateDatabase method has no default SQL Server type mapping for these types.
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2
I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...
I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...