gpt4 book ai didi

Azure Easy Tables - 仅加载一列

转载 作者:行者123 更新时间:2023-12-02 06:46:43 34 4
gpt4 key购买 nike

是否有某种方法可以从 Azure Easy Tables 中仅获取一行的一个数据列?

例如,Xamarin.Forms 应用程序会将项目名称发送到 Azure,并仅获取项目创建日期时间。

最佳答案

下面是一个示例,我们只想从 Dog 表中选择 Name 列。

此示例使用 Azure Mobile ClientAzure Mobile Client SQL NuGet 包。

型号

using Microsoft.WindowsAzure.MobileServices;
using Newtonsoft.Json;

namespace SampleApp
{
public class Dog
{
public string Name { get; set; }
public string Breed { get; set; }
public int Age { get; set; }

[JsonProperty(PropertyName = "id")]
public string Id { get; set; }

[CreatedAt]
public DateTimeOffset CreatedAt { get; set; }

[UpdatedAt]
public DateTimeOffset UpdatedAt { get; set; }

[Version]
public string AzureVersion { get; set; }

[Deleted]
public bool IsDeleted { get; set; }
}
}

逻辑

using System;
using System.IO;
using System.Linq;
using System.Threading.Tasks;
using System.Collections.Generic;

using Microsoft.WindowsAzure.MobileServices;
using Microsoft.WindowsAzure.MobileServices.Sync;
using Microsoft.WindowsAzure.MobileServices.SQLiteStore;

namespace SampleApp
{
public class MobileClientService
{
bool isMobileClientInitialized;
MobileServiceClient mobileClient;

public async Task<string> GetDogName(string id)
{
await InitializeMobileClient();

var dog = await mobileClient.GetSyncTable<Dog>().LookupAsync(id);
var dogName = dog.Name;

return dogName;
}

public async Task<IEnumerable<string>> GetDogNames()
{
await InitializeMobileClient();

var dogNameList = await mobileClient.GetSyncTable<Dog>().Select(x => x.Name).ToEnumerableAsync();

return dogNameList;
}

async Task InitializeMobileClient()
{
if(isMobileClientInitialized)
return;

mobileClient = new MobileServiceClient("Your Azure Mobile Client Url");

var path = Path.Combine(MobileServiceClient.DefaultDatabasePath, "app.db");
var store = new MobileServiceSQLiteStore(path);
store.DefineTable<Dog>();
//ToDo Define all remaining tables

await MobileServiceClient.SyncContext.InitializeAsync(store, new MobileServiceSyncHandler());

}
}
}

关于Azure Easy Tables - 仅加载一列,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/49028633/

34 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com