本文整理汇总了C#中SqlCeConnection.OpenAsync方法的典型用法代码示例。如果您正苦于以下问题：C# SqlCeConnection.OpenAsync方法的具体用法？C# SqlCeConnection.OpenAsync怎么用？C# SqlCeConnection.OpenAsync使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SqlCeConnection的用法示例。
在下文中一共展示了SqlCeConnection.OpenAsync方法的11个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetAll
public async Task<IEnumerable<dynamic>> GetAll()
{
using (var connection = new SqlCeConnection(_connString))
{
await connection.OpenAsync();
IEnumerable<dynamic> tasks = await connection.QueryAsync<dynamic>("select Id as id, Title as title, Description as description, CreatedDate as createdDate from Tasks;");
return tasks;
}
}示例2: Execute
public void Execute(string output)
{
using (var connection = new SqlCeConnection(connString))
{
connection.OpenAsync().Wait();
var command = connection.CreateCommand();
command.CommandText = output;
command.CommandType = System.Data.CommandType.Text;
command.ExecuteNonQueryAsync().Wait();
connection.Close();
}
}示例3: AddHistoricMessage
private async static Task AddHistoricMessage(MsSqlMessageStore sSqlMessageStore, Message message)
{
var sql = string.Format("INSERT INTO {0} (MessageId, MessageType, Topic, Body) VALUES (@MessageId, @MessageType, @Topic, @Body)", TableName);
var parameters = new[]
{
new SqlCeParameter("MessageId", message.Id),
new SqlCeParameter("MessageType", message.Header.MessageType.ToString()),
new SqlCeParameter("Topic", message.Header.Topic),
new SqlCeParameter("Body", message.Body.Value),
};
using (var connection = new SqlCeConnection(ConnectionString))
using (var command = connection.CreateCommand())
{
await connection.OpenAsync();
command.CommandText = sql;
command.Parameters.AddRange(parameters);
await command.ExecuteNonQueryAsync();
}
}示例4: GetTheFirstErrorHoursAsync
public async Task<int> GetTheFirstErrorHoursAsync()
{
using (var sqlConn = new SqlCeConnection(ConnectionString))
using (var cmd = sqlConn.CreateCommand())
{
try
{
cmd.CommandText = string.Format("SELECT ABS(DATEDIFF(HH, Min([ErrorDateTime]), GETDATE())) FROM ErrorLog");
await sqlConn.OpenAsync();
return await cmd.ExecuteScalarAsync() as int? ?? 0;
}
finally
{
sqlConn.Close();
}
}
}示例5: CountAsync
public async Task<int> CountAsync()
{
using (var sqlConn = new SqlCeConnection(ConnectionString))
using (var cmd = sqlConn.CreateCommand())
{
try
{
cmd.CommandText = string.Format("Select Count(ErrorId) From ErrorLog");
await sqlConn.OpenAsync();
return await cmd.ExecuteScalarAsync() as int? ?? 0;
}
finally
{
sqlConn.Close();
}
}
}示例6: DeleteAsync
public async Task DeleteAsync(int id)
{
// If error is not exist in list then exit
if (!ErrorIds.ContainsKey(id)) return;
using (var sqlConn = new SqlCeConnection(ConnectionString))
using (var cmd = sqlConn.CreateCommand())
{
try
{
cmd.CommandText = string.Format("Delete From ErrorLog Where ErrorId = {0}", id);
await sqlConn.OpenAsync();
await cmd.ExecuteNonQueryAsync();
ErrorIds.Remove(id);
}
finally
{
sqlConn.Close();
}
}
}示例7: GetErrorAsync
public async Task<ProxyError> GetErrorAsync(int id)
{
using (var sqlConn = new SqlCeConnection(ConnectionString))
using (var cmd = sqlConn.CreateCommand())
{
try
{
cmd.CommandText = string.Format("Select * From ErrorLog Where ErrorId = {0}", id);
await sqlConn.OpenAsync();
return await cmd.ExecuteScalarAsync() as ProxyError;
}
finally
{
sqlConn.Close();
}
}
}示例8: UpdateAsync
public async Task UpdateAsync(Error error)
{
// If error is not exist in list or error state is now at unhandled exception state then exit
if (!ErrorIds.ContainsKey(error.Id) || !ErrorIds[error.Id]) return;
using (var sqlConn = new SqlCeConnection(ConnectionString))
using (var cmd = sqlConn.CreateCommand())
{
cmd.CommandText =
string.Format("UPDATE [ErrorLog] SET [DuplicateNo] = [DuplicateNo] + 1 {0} WHERE ErrorId = @id",
error.IsHandled ? "" : ", [IsHandled] = @isHandled, [StackTrace] = @stackTrace");
//
// Add parameters to command, which will be passed to the stored procedure
cmd.Parameters.AddWithValue("@id", error.Id);
if (!error.IsHandled) // Just in Unhandled Exceptions
{
cmd.Parameters.AddWithValue("@isHandled", error.IsHandled);
cmd.Parameters.AddWithValue("@stackTrace", SubLimitString(error.StackTrace));
}
try
{
await sqlConn.OpenAsync();
await cmd.ExecuteNonQueryAsync();
ErrorIds[error.Id] = error.IsHandled;
}
finally
{
sqlConn.Close();
}
}
}示例9: InsertAsync
public async Task InsertAsync(Error error)
{
using (var sqlConn = new SqlCeConnection(ConnectionString))
using (var cmd = sqlConn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO [ErrorLog]
([ErrorId]
,[ServerDateTime]
,[Host]
,[User]
,[IsHandled]
,[Type]
,[AppName]
,[CurrentCulture]
,[CLRVersion]
,[Message]
,[Source]
,[StackTrace]
,[ModuleName]
,[MemberType]
,[Method]
,[Processes]
,[ErrorDateTime]
,[OS]
,[IPv4Address]
,[MACAddress]
,[HResult]
,[Line]
,[Column]
,[ScreenCapture]
,[DuplicateNo]
,[Data])
VALUES (
@Id
,@ServerDateTime
,@Host
,@User
,@IsHandled
,@Type
,@AppName
,@CurrentCulture
,@CLRVersion
,@Message
,@Source
,@StackTrace
,@ModuleName
,@MemberType
,@Method
,@Processes
,@ErrorDateTime
,@OS
,@IPv4Address
,@MACAddress
,@HResult
,@Line
,@Column
,@Snapshot
,@Duplicate
,@Data
)";
//
// Add parameters to command, which will be passed to the stored procedure
cmd.Parameters.AddWithValue("@Id", error.Id);
cmd.Parameters.AddWithValue("@ServerDateTime", error.ServerDateTime);
cmd.Parameters.AddWithValue("@Host", error.Host);
cmd.Parameters.AddWithValue("@User", error.User);
cmd.Parameters.AddWithValue("@IsHandled", error.IsHandled);
cmd.Parameters.AddWithValue("@Type", error.ErrorType);
cmd.Parameters.AddWithValue("@AppName", error.AppName);
cmd.Parameters.AddWithValue("@CurrentCulture", error.CurrentCulture);
cmd.Parameters.AddWithValue("@CLRVersion", error.ClrVersion);
cmd.Parameters.AddWithValue("@Message", error.Message);
cmd.Parameters.AddWithValue("@Source", error.Source ?? "Source Not Found");
cmd.Parameters.AddWithValue("@StackTrace", SubLimitString(error.StackTrace));
cmd.Parameters.AddWithValue("@ModuleName", error.ModuleName);
cmd.Parameters.AddWithValue("@MemberType", error.MemberType);
cmd.Parameters.AddWithValue("@Method", error.Method);
cmd.Parameters.AddWithValue("@Processes", SubLimitString(error.Processes));
cmd.Parameters.AddWithValue("@ErrorDateTime", error.ErrorDateTime);
cmd.Parameters.AddWithValue("@OS", error.OS);
cmd.Parameters.AddWithValue("@IPv4Address", error.IPv4Address);
cmd.Parameters.AddWithValue("@MACAddress", error.MacAddress);
cmd.Parameters.AddWithValue("@HResult", error.HResult);
cmd.Parameters.AddWithValue("@Line", error.LineColumn.Line);
cmd.Parameters.AddWithValue("@Column", error.LineColumn.Column);
cmd.Parameters.AddWithValue("@Duplicate", error.Duplicate);
cmd.Parameters.AddWithValue("@Data", SubLimitString(error.Data));
if (error.Snapshot == null) cmd.Parameters.AddWithValue("@Snapshot", DBNull.Value);
else cmd.Parameters.AddWithValue("@Snapshot", error.Snapshot.ToBytes());
try
{
await sqlConn.OpenAsync();
await cmd.ExecuteNonQueryAsync();
ErrorIds.Add(error.Id, error.IsHandled);
}
finally
{
//.........这里部分代码省略.........
示例10: Post
public async Task<HttpResponseMessage> Post(JObject value)
{
dynamic data = value;
IEnumerable<int> result;
using (var connection = new SqlCeConnection(_connString))
{
await connection.OpenAsync();
connection.Execute(
"insert into Tasks (Title, Description, CreatedDate) values (@title, @description, @createdDate);",
new
{
title = (string)data.title,
description = (string)data.description,
createdDate = DateTime.Parse((string)data.createdDate)
}
);
result = await connection.QueryAsync<int>("select max(Id) as id from Tasks;");
}
int id = result.First();
data.id = id;
var response = Request.CreateResponse(HttpStatusCode.Created, (JObject)data);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { controller = "Tasks", id = id }));
return response;
}示例11: Get
public async Task<dynamic> Get(int id)
{
using (var connection = new SqlCeConnection(_connString))
{
await connection.OpenAsync();
IEnumerable<dynamic> tasks = await connection.QueryAsync<dynamic>("select Id as id, Title as title, Description as description, CreatedDate as createdDate from Tasks where Id = @id;", new { id = id });
if (!tasks.Any())
throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Task not found"));
return tasks.First();
}
}