本文整理汇总了C#中SqlCeCommand.?.Dispose方法的典型用法代码示例。如果您正苦于以下问题：C# SqlCeCommand.?.Dispose方法的具体用法？C# SqlCeCommand.?.Dispose怎么用？C# SqlCeCommand.?.Dispose使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SqlCeCommand的用法示例。
在下文中一共展示了SqlCeCommand.?.Dispose方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Main
static void Main(string[] args)
{
var connectionString = $"Data Source = \"{SdfFilePath}\"";
SqlCeConnection connection = null;
SqlCeCommand command = null;
SqlCeDataReader reader = null;
try
{
connection = new SqlCeConnection(connectionString);
connection.Open();
var query = "SELECT * FROM Petitioners";
command = new SqlCeCommand(query, connection);
reader = command.ExecuteReader();
var json = new List<ExpandoObject>();
while (reader.Read())
{
var item = new ExpandoObject();
Enumerable.Range(0, reader.FieldCount)
.Skip(1)
.Select(i => new { Field = reader.GetName(i), Value = reader[i] })
.ToList()
.ForEach(data => ((IDictionary<string, Object>)item)[data.Field] = data.Value);
json.Add(item);
}
using (var jsonWriter = new StreamWriter($"{JsonFilePath}", false, Encoding.Default))
{
jsonWriter.WriteLine(JsonConvert.SerializeObject(json, Formatting.Indented));
};
}
catch (Exception exception)
{
Console.WriteLine(exception);
}
finally
{
reader?.Close();
command?.Dispose();
connection?.Close();
}
Console.WriteLine($"{Environment.NewLine}Press any key to exit.");
Console.ReadKey();
}