ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pavel Tupitsyn <ptupit...@gridgain.com>
Subject Re: .net configure sql query with c# code, when execute query, return empty set
Date Mon, 04 Jul 2016 10:45:42 GMT
Hi,

You have to use Ignite Binary Serialization to enable SQL queries [1].
To do that, remove [Serializable] attribute and register Employee class in
the configuration:

            var cfg = new IgniteConfiguration
            {
                CacheConfiguration = new[]
                {
                    new CacheConfiguration("mycache", typeof(Employee))
                },
                BinaryConfiguration = new
BinaryConfiguration(typeof(Employee))
            };


[1] https://apacheignite-net.readme.io/docs/serialization

On Mon, Jul 4, 2016 at 1:21 PM, November <yufeng7144@126.com> wrote:

> Here is my code. Thanks.
>
> namespace FirstIgnite
> {
>     class Program
>     {
>         static void Main(string[] args)
>         {
>             var cfg = new IgniteConfiguration
>             {
>                 CacheConfiguration = new[]
>                 {
>                     new CacheConfiguration("mycache", typeof(Employee))
>                 }
>             };
>
>             var ignite = Ignition.Start(cfg);
>
>             var cache = ignite.GetCache<long, Employee>("mycache");
>
>             Employee person1 = new Employee();
>             person1.Age = 18;
>             person1.Name = "yf";
>             person1.Salary = 1000;
>
>             Employee person2 = new Employee();
>             person2.Age = 20;
>             person2.Name = "sm";
>             person2.Salary = 10000;
>
>             cache.Put(1, person1);
>             cache.Put(2, person2);
>
>             var sql = new SqlQuery(typeof(Employee), "Salary > 10");
>
>             var cursor = cache.Query(sql);
>
>             foreach (var cacheEntry in cursor)
>                 Console.WriteLine("{0} | {1} | {2}", cacheEntry.Value.Age,
> cacheEntry.Value.Name, cacheEntry.Value.Salary);
>
>             Console.WriteLine("Press any key to exit");
>             Console.ReadKey();
>         }
>     }
>
>     [Serializable]
>     public class Employee
>     {
>         [QuerySqlField]
>         public string Name { get; set; }
>
>         [QuerySqlField]
>         public long Salary { get; set; }
>
>         [QuerySqlField]
>         public int Age { get; set; }
>     }
> }
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/net-configure-sql-query-with-c-code-when-execute-query-return-empty-set-tp6069.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>

Mime
View raw message