Can you try with this code snippet? I've tested it, and it works without
exceptions.
var selectedValue = database
.Select()
.From("Person")
.Where("lastName")
.Equals("Murphy")
.ToList();
Hope it helps.
Il giorno venerdì 9 settembre 2016 15:18:04 UTC+2, Ticket Voodoo ha scritto:
>
> running the query
> SELECT FROM Person WHERE lastName = 'Murphy'
> in Studio brings back results so I know that the query works as well
> against the VehicleHistoryGraph example db.
>
> On Friday, September 9, 2016 at 2:13:20 PM UTC+1, Ticket Voodoo wrote:
>>
>> line 106 is the .Query
>>
>> thanks :-)
>> screen shot below
>>
>>
>>
>>
>>
>>
>> On Friday, September 9, 2016 at 2:08:54 PM UTC+1, Oleksandr Gubchenko
>> wrote:
>>>
>>> You have an ArrayIndexOutOfBoundsException, can you post the line
>>> numbers of your code?
>>>
>>> Il giorno venerdì 9 settembre 2016 12:53:50 UTC+2, Ticket Voodoo ha
>>> scritto:
>>>>
>>>> I have the following 2 tests (see code below)
>>>> The first test works fine CanQUeryDBNoParams,
>>>> However, the second test CanQueryDBWithParams
>>>> fails with the following error which I have unsuccessfuly tried to
>>>> google for help with to no avail, so any help with this would be greatly
>>>> appreciated.
>>>>
>>>> I am using the latest .net from nuget against the lastest OrientDB
>>>> running on windows 10, as the first test works I know the code and
>>>> database
>>>> works.
>>>>
>>>> error:
>>>> Test Name: CanQueryDBWithParams
>>>> Test FullName:
>>>> UnitTestTVGraphDB.UnitTestTVGraphDB.CanQueryDBWithParams
>>>> Test Source:
>>>> E:\TVMercurialSCM\johnc\Source\TicketVoodooGraphDB\UnitTestTVGraphDB\UnitTestTVGraphDB.cs
>>>>
>>>> : line 91
>>>> Test Outcome: Failed
>>>> Test Duration: 0:00:00.0297952
>>>>
>>>> Result StackTrace:
>>>> at Orient.Client.Protocol.Response.Receive()
>>>> at
>>>> Orient.Client.Protocol.Connection.ExecuteOperationInternal(IOperation
>>>> operation)
>>>> at Orient.Client.Protocol.Connection.ExecuteOperation(IOperation
>>>> operation)
>>>> at Orient.Client.API.Query.PreparedQuery.RunInternal()
>>>> at Orient.Client.API.Query.PreparedQuery.Run(String[] properties)
>>>> at UnitTestTVGraphDB.UnitTestTVGraphDB.CanQueryDBWithParams() in
>>>> E:\TVMercurialSCM\johnc\Source\TicketVoodooGraphDB\UnitTestTVGraphDB\UnitTestTVGraphDB.cs:line
>>>>
>>>> 106
>>>> Result Message:
>>>> Test method UnitTestTVGraphDB.UnitTestTVGraphDB.CanQueryDBWithParams
>>>> threw exception:
>>>> Orient.Client.OException:
>>>> com.orientechnologies.orient.core.exception.OSerializationException: Error
>>>> on unmarshalling content. Class: q
>>>> DB name="VehicleHistoryGraph"
>>>> java.lang.ArrayIndexOutOfBoundsException:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> [TestMethod]
>>>> public void CanQueryDBNoParams()
>>>> {
>>>>
>>>> using (GraphDbContext dbContext = new GraphDbContext())
>>>> {
>>>>
>>>> using (ODatabase database = new
>>>> ODatabase(GraphDbConnection.DatabaseAlias))
>>>> {
>>>> List<ODocument> result = database
>>>> .Select("firstName").As("firstName")
>>>>
>>>> .Also("lastName").As("lastName")
>>>> .Also("fullName").As("fullName")
>>>> .Also("gender").As("gender")
>>>> .Also("birthday").As("birthday")
>>>> .From<Person>()
>>>> .OrderBy("lastName").Descending()
>>>> .ToList();
>>>> Assert.IsNotNull(result);
>>>> Assert.IsTrue(result.Count > 0);
>>>> Console.WriteLine(String.Format("result count:{0}",
>>>> result.Count));
>>>>
>>>> foreach (var doc in result)
>>>> {
>>>> Console.WriteLine(String.Format("CanQueryDBNoParams
>>>> doc.OClassName:{0}", doc.OClassName ));
>>>> }
>>>> }
>>>> }
>>>> }
>>>>
>>>> [TestMethod]
>>>> public void CanQueryDBWithParams()
>>>> {
>>>>
>>>> using (GraphDbContext dbContext = new GraphDbContext())
>>>> {
>>>>
>>>> using (ODatabase database = new
>>>> ODatabase(GraphDbConnection.DatabaseAlias))
>>>> {
>>>>
>>>> var query = new PreparedQuery(" SELECT FROM Person WHERE
>>>> lastName = ? ", "*:0");
>>>>
>>>> var selectedValue = database
>>>> .Query(query)
>>>> .Run("Murphy")
>>>> .ToList();
>>>>
>>>> Assert.IsTrue(selectedValue.Count > 0);
>>>>
>>>> }
>>>> }
>>>> }
>>>>
>>>>
>>>>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
