GitHub

Performing Disconnected Operations: Programming with DataSets and Datatables with C#

DataSets and DataTables You create an instance of a DataSet by calling the DataSet constructor. Specify an optional name argument. If you do not specify a name for ...
GitHub

水平分割したテーブルの利用方法

Doma では、データ分散のためにテーブルを水平分割するにはどのような Dao を作ればよいでしょうか。 例えば、1 つのテーブルを同じスキーマのまま books_p1, books_p2, ... books_pX と作っていき ...
Ars Technica

Powershell. SQL Query. How to determine if a query returns no results?

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 minutes ...
Redmond Pie

Inserting and Retrieving images from SQL Server Database using C#

I think storing images in a database can save a developer loads of time and can ease his life while dealing with visuals, either creating a local application or a web application. Think of storing ...
Visual Studio Magazine

Reduce Code and Server Roundtrips

Table-valued parameters are the long-awaited solution to a specific SQL Server shortcoming that has plagued developers for quite some time: SQL Server doesn't provide a built-in way to send multiple ...