public void InitPveMap(int nPveID, int nCompleteTime, RemoteTable pveValue) { KPve pveInfo = KConfigFileManager.GetInstance().pveList.getData(nPveID.ToString()); showText = pveInfo.Text; enterTime = (int)PlayerManager.GetInstance().MajorPlayer.onlineTime; MapName.text = pveInfo.Name; ProcessTime.text = GiftItem.FormatTime(nCompleteTime); completeTime = nCompleteTime; exsistTime = pveInfo.tExistTime; pveID = nPveID; UpdateTime(); for (int i = 0; i < 9; i++) { int nValue = pveValue[i]; mapValue[i] = nValue; } UpdateValue(); ShowProcess(); }
public void LinqODataWithSelectConversions() { // Arrange var client = GetMockClient(); var table = new RemoteTable <ClientMovie>("movies", client); var query = new TableQuery <ClientMovie>(table); DateTimeOffset dto1 = new(1994, 10, 14, 0, 0, 0, TimeSpan.Zero); const string dts1 = "1994-10-14T00:00:00.000Z"; // Need to make sure the $select statement is added in the right spot. var expected = NormalizeQueryString($"__includedeleted=true&$count=true&$filter=(updatedAt gt cast({dts1},Edm.DateTimeOffset))&$orderby=updatedAt&$skip=25&$select=id,title"); // Act TableQuery <SelectResult> tableQuery = query .Where(x => x.UpdatedAt > dto1) .IncludeDeletedItems() .OrderBy(x => x.UpdatedAt) .IncludeTotalCount() .Skip(25) .Select(m => new SelectResult { Id = m.Id, Title = m.Title }) as TableQuery <SelectResult>; var actual = NormalizeQueryString(Uri.UnescapeDataString(tableQuery.ToODataString())); // Assert Assert.Equal(expected, actual); }
public object ShowPveView(int nPveID, float fCompleteTime, RemoteTable award) { KPve pveInfo = KConfigFileManager.GetInstance().pveList.getData(nPveID.ToString()); Open(null); SuccSprite1.gameObject.SetActive(false); SuccSprite2.gameObject.SetActive(false); SuccSprite3.gameObject.SetActive(false); if (fCompleteTime > pveInfo.tNormalTime) { SuccSprite1.gameObject.SetActive(true); nShowStar = 1; } else if (fCompleteTime > pveInfo.tGoodTime) { SuccSprite2.gameObject.SetActive(true); Star3.gameObject.SetActive(false); nShowStar = 2; } else { SuccSprite3.gameObject.SetActive(true); nShowStar = 3; } CompleteTimeLabel.text = GiftItem.FormatTime((int)fCompleteTime); ShowAward(award); showTime = (int)PlayerManager.GetInstance().MajorPlayer.onlineTime; return(null); }
// Example of scenario such as storing a query in a database and retreiving it // later into the same object model. public static void DLinqQuerySerializationSamples() { Console.WriteLine("DLINQ BASIC SAMPLE - Single Object Model used on both sides of serialization:"); // Write the query against RemoteTable<Customer>, a dummy implementation // of IQueryable RemoteTable <Customer> customers = new RemoteTable <Customer>(); var query = from c in customers where c.City == "London" select new { c.CompanyName, c }; XElement queryXml = query.SerializeQuery(); // On the other side - create a new DataContext, and deserialize // the query xml into a query against this datacontext NorthwindDataContext dbOther = new NorthwindDataContext(); IQueryable queryAfter = dbOther.DeserializeQuery(queryXml); // Print out the IQueryable: "(x, y) => x + y" Console.WriteLine("Deserialized IQueryable:"); Console.WriteLine(" " + queryAfter.ToString()); Console.WriteLine("\n Results: "); queryAfter.Cast <object>().ToList().ForEach(n => Console.WriteLine(" " + n.ToString())); Console.WriteLine(); }
// Example of scenario such as storing a query in a database and retreiving it // later into the same object model. public static void DLinqQuerySerializationSamples() { Console.WriteLine("DLINQ BASIC SAMPLE - Single Object Model used on both sides of serialization:"); // Write the query against RemoteTable<Customer>, a dummy implementation // of IQueryable RemoteTable<Customer> customers = new RemoteTable<Customer>(); var query = from c in customers where c.City == "London" select new {c.CompanyName,c}; XElement queryXml = query.SerializeQuery(); // On the other side - create a new DataContext, and deserialize // the query xml into a query against this datacontext NorthwindDataContext dbOther = new NorthwindDataContext(); IQueryable queryAfter = dbOther.DeserializeQuery(queryXml); // Print out the IQueryable: "(x, y) => x + y" Console.WriteLine("Deserialized IQueryable:"); Console.WriteLine(" " + queryAfter.ToString()); Console.WriteLine("\n Results: "); queryAfter.Cast<object>().ToList().ForEach(n => Console.WriteLine(" " + n.ToString())); Console.WriteLine(); }
public void Ctor_SetsInternals() { var client = GetMockClient(); var sut = new RemoteTable("movies", client); Assert.Equal("movies", sut.TableName); Assert.Same(client, sut.ServiceClient); }
public void IncludeTotalCount_Disabled_RemovesKey() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table).IncludeTotalCount(false) as TableQuery <IdEntity>; Assert.False(query.RequestTotalCount); }
public void WithParameter_Illegal_Throws(string key, string value) { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table); Assert.Throws <ArgumentException>(() => query.WithParameter(key, value)); }
public void Take_ThrowsOutOfRange([CombinatorialValues(-10, -1, 0)] int take) { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table); Assert.Throws <ArgumentOutOfRangeException>(() => query.Take(take)); }
public void ToODataString_ThenBy_ThrowsNotSupported() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table).ThenBy(m => m.Id.ToLower()) as TableQuery <IdEntity>; Assert.Throws <NotSupportedException>(() => query.ToODataString()); }
public void ToODataString_Where_ThrowsNotSupported() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table).ThenByDescending(m => m.Id.Normalize() == "foo") as TableQuery <IdEntity>; Assert.Throws <NotSupportedException>(() => query.ToODataString()); }
public void WithParameters_Null_Throws() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table); Assert.Throws <ArgumentNullException>(() => query.WithParameters(null)); }
public void IncludeTotalCount_Enabled_AddsKey() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table).IncludeTotalCount(true) as TableQuery <IdEntity>; Assert.True(query.RequestTotalCount); }
public void ToODataString_Where_IsWellFormed() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table).Where(m => m.Id == "foo") as TableQuery <IdEntity>; var odata = query.ToODataString(); Assert.Equal("$filter=(id eq 'foo')", odata); }
public void RemoteTableExpressionTest() { var rt = new RemoteTable <RTItem>(); var query = rt.Where(x => x.name == "dd"); Expression <Func <int, bool> > expression = x => (-x > 5) ? true : false; var el = rt.SerializeQuery(); }
public void ToODataString_ThenByDescending_IsWellFormed() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table).ThenByDescending(m => m.Id) as TableQuery <IdEntity>; var odata = query.ToODataString(); Assert.Equal("$orderby=id desc", odata); }
public void ThenByDescending_Null_Throws() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table); Expression <Func <IdEntity, string> > keySelector = null; Assert.Throws <ArgumentNullException>(() => query.ThenByDescending(keySelector)); }
public void ToODataString_Take_IsWellFormed() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table).Take(5) as TableQuery <IdEntity>; var odata = query.ToODataString(); Assert.Equal("$top=5", odata); }
public void WithParameter_Overwrites() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table).WithParameter("testkey", "testvalue"); var actual = query.WithParameter("testkey", "replacement") as TableQuery <IdEntity>; AssertEx.Contains("testkey", "replacement", actual.Parameters); }
public void Select_Null_Throws() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table); Expression <Func <IdEntity, IdOnly> > selector = null; Assert.Throws <ArgumentNullException>(() => query.Select(selector)); }
/// <summary> /// Returns the result of the query as an <see cref="IAsyncEnumerable{T}"/>. /// </summary> /// <returns>The list of items as an <see cref="IAsyncEnumerable{T}"/></returns> public IAsyncEnumerable<T> ToAsyncEnumerable() { if (IsOfflineEnabled) { var offlineTable = new OfflineTable<T>(RemoteTable.TableName, RemoteTable.ServiceClient); return offlineTable.GetAsyncItems(this); } return RemoteTable.GetAsyncItems(this); }
public void Linq_InvalidOrderBy_Lambda() { // Arrange var client = GetMockClient(); var table = new RemoteTable <ClientMovie>("movies", client); var query = new TableQuery <ClientMovie>(table).OrderBy(m => m.Id == "foo" ? "yes" : "no") as TableQuery <ClientMovie>; Assert.Throws <NotSupportedException>(() => query.ToODataString()); }
public void Where_Null_Throws() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table); Expression <Func <IdEntity, bool> > predicate = null; Assert.Throws <ArgumentNullException>(() => query.Where(predicate)); }
public void ToODataString_IncludeDeletedItems_IsWellFormed() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table).IncludeDeletedItems() as TableQuery <IdEntity>; var odata = query.ToODataString(); Assert.Equal("__includedeleted=true", odata); }
public void Linq_InvalidOrderBy_ToString() { // Arrange var client = GetMockClient(); var table = new RemoteTable <ClientMovie>("movies", client); var query = new TableQuery <ClientMovie>(table).OrderBy(m => m.ReleaseDate.ToString("o")) as TableQuery <ClientMovie>; Assert.Throws <NotSupportedException>(() => query.ToODataString()); }
public void Linq_NegateNotSupported() { // Arrange var client = GetMockClient(); var table = new RemoteTable <ClientMovie>("movies", client); var query = new TableQuery <ClientMovie>(table).Where(m => (-m.Year) <= -2000) as TableQuery <ClientMovie>; Assert.Throws <NotSupportedException>(() => query.ToODataString()); }
public void IncludeDeletedItems_Disabled_WorksWithEmptyParameters() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table); var actual = query.IncludeDeletedItems(false) as TableQuery <IdEntity>; Assert.False(actual.Parameters.ContainsKey("__includedeleted")); }
public void Ctor_BlankSetup() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table); Assert.Same(table, query.RemoteTable); Assert.IsAssignableFrom <IQueryable <IdEntity> >(query.Query); Assert.Empty(query.Parameters); }
public void ToODataString_WithParameter_EncodesValue() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table).WithParameter("testkey", "test value") as TableQuery <IdEntity>; var odata = query.ToODataString(); Assert.Equal("testkey=test%20value", odata); }
public void ToODataString_DefaultIncludeParameters() { // Arrange var client = GetMockClient(); var table = new RemoteTable <ClientMovie>("movies", client); var query = new TableQuery <ClientMovie>(table).OrderBy(m => m.ReleaseDate).WithParameter("foo", "bar") as TableQuery <ClientMovie>; var actual = query.ToODataString(); Assert.Equal("$orderby=releaseDate&foo=bar", actual); }
public void IncludeDeletedItems_Enabled_ChangesKey() { var client = GetMockClient(); RemoteTable <IdEntity> table = client.GetRemoteTable <IdEntity>("movies") as RemoteTable <IdEntity>; var query = new TableQuery <IdEntity>(table); query.Parameters.Add("__includedeleted", "test"); var actual = query.IncludeDeletedItems() as TableQuery <IdEntity>; AssertEx.Contains("__includedeleted", "true", actual.Parameters); }
// Example of querying using LINQ against a LINQ to SQL implementation hidden behind a WCF service // Note that no database is being directly referenced - all types and calls are proxies generated by // the service reference. public static void AcrossTheWireSerializationSamples() { Console.WriteLine("DLINQ ACROSS THE WIRE SAMPLE - Query against an IQueryable wrapper over a web service:"); // Query is against a RemoteTable which is a proxy for the the WCF service which executes the DLinq query // on the server. Note that the elements are the service-reference generated types that align with the // DLinq mapping types via the DataContracts. var queryService = new RemoteTable<RemoteQueryService.ServiceReference.Customer>(); var query = from c in queryService where c.City == "London" orderby c.CustomerID select (from o in c.Orders orderby o.OrderDate select o.OrderDate).First(); Console.WriteLine("\n Query Results: "); foreach (var c in query) Console.WriteLine(" " + c.Value.ToShortDateString()); }