C# Database.ExecuteAsync方法代码示例

		public async Task CreateDbAsync()
		{
			db = new Database(_connectionStringName);
			var all = Utils.LoadTextResource(string.Format("AsyncPoco.Tests.{0}_init.sql", _connectionStringName));
			foreach(var sql in all.Split(';').Select(s => s.Trim()).Where(s => s.Length > 0))
				await db.ExecuteAsync(sql);
		}

		public Task CreateDbAsync()
		{
			db = new Database(_connectionStringName);
			//await db.OpenSharedConnectionAsync();		// <-- Wow, this is crucial to getting SqlCE to perform.
														// true, but it was causing AsyncPoco tests pass when they should have failed
			return db.ExecuteAsync(Utils.LoadTextResource(string.Format("AsyncPoco.Tests.{0}_init.sql", _connectionStringName)));
		}

 public async Task RemoveDeviceFromRoomAsync(string gatewayName, string deviceId)
 {
     using (var database = new Database("ConnectionString"))
     {
         const string sql = "delete from RoomDevice where Gateway = @0 and Id = @1)";
         await database.ExecuteAsync(sql, gatewayName, deviceId);
     }
 }

		public async Task CreateDbAsync()
		{
			db = new Database(_connectionStringName);
			await db.ExecuteAsync(@"

DROP TABLE IF EXISTS posts;
DROP TABLE IF EXISTS authors;

CREATE TABLE posts (
	id				bigint AUTO_INCREMENT NOT NULL,
	title			varchar(127) NOT NULL,
	author			bigint NOT NULL,
	PRIMARY KEY (id)
) ENGINE=INNODB;

CREATE TABLE authors (
	id				bigint AUTO_INCREMENT NOT NULL,
	name			varchar(127) NOT NULL,
	PRIMARY KEY (id)
) ENGINE=INNODB;

			");


			var a1 = new author();
			a1.name = "Bill";
			await db.InsertAsync(a1);

			var a2 = new author();
			a2.name = "Ted";
			await db.InsertAsync(a2);

			var p = new post();
			p.title = "post1";
			p.author = a1.id;
			await db.InsertAsync(p);

			p = new post();
			p.title = "post2";
			p.author = a1.id;
			await db.InsertAsync(p);

			p = new post();
			p.title = "post3";
			p.author = a2.id;
			await db.InsertAsync(p);

		}

        public async Task AddDeviceToRoomAsync(string gatewayName, string deviceId, string roomId)
        {
            using (var database = new Database("ConnectionString"))
            {
                const string sql = @"
if (select count(*) from RoomDevice where Gateway = @0 and Id = @1) > 0
begin
  update RoomDevice set RoomId = @2 where Gateway = @0 and Id = @1
end
else
begin
  insert into RoomDevice (Gateway, Id, RoomId) values (@0, @1, @2)
end";

                await database.ExecuteAsync(sql, gatewayName, deviceId, roomId);
            }
        }

        async Task StoreHL7(Database db, XDocument xDoc, string hl7, string fileName)
        {
            var messageControlId = (from elem in xDoc.Descendants("MSH.10") select elem.Value).FirstOrDefault().ToDecimal();

            var exists = await db.ExistsAsync<HL7>("MessageControlId = @0", messageControlId);

            var record = new HL7();
            record.MessageControlId = messageControlId;
            record.MessageTimeStamp = (from elem in xDoc.Descendants("MSH.7") select elem.Value).FirstOrDefault().ToDatetime("yyyyMMddHHmmss", new DateTime(3000, 1, 1));
            record.MessageType = (from elem in xDoc.Descendants("MSH.9.1") select elem.Value).FirstOrDefault();
            record.EventType = (from elem in xDoc.Descendants("MSH.9.2") select elem.Value).FirstOrDefault();
            record.Message = hl7;
            record.FileName = fileName;

            if (record.MessageControlId == decimal.Zero || record.MessageType.IsNullOrEmpty() || record.EventType.IsNullOrEmpty())
                return;

            if (exists)
                await db.UpdateAsync("HL7v23.dbo.HL7", "MessageControlId", record);
            else
                await db.InsertAsync("HL7v23.dbo.HL7", "MessageControlId", false, record);

            if (record.MessageType == "MFN")
                await StoreMFN(db, xDoc, exists);
            else if (record.MessageType == "ADT")
                await StoreADT(db, xDoc, exists);
            else if (record.MessageType == "BAR")
                await StoreBAR(db, xDoc, exists);
            else
            {
                var message = string.Format("Need to store unsupported Message with MessageType {0}: {1}", record.MessageType, hl7);
                LogException(message, new Exception(message), null);   
            }

            await db.ExecuteAsync(@"update ZISv21.dbo.LastProcessedMessage
set MessageControlId = @0 
where [application] = @1 and MessageControlId < @0", messageControlId, "HL7v23");
        }