[Firebird-net-provider] [FB-Tracker] Created: (DNET-690) Named parameters not reconized in SqlQuery

[Fabiano Rezende (JIRA)]

Named parameters not reconized in SqlQuery
--

 Key: DNET-690
 URL: http://tracker.firebirdsql.org/browse/DNET-690
 Project: .NET Data provider
  Issue Type: Bug
  Components: Entity Framework support
Affects Versions: 5.0.5.0
 Environment: Windows 10 64 bits
Reporter: Fabiano Rezende
Assignee: Jiri Cincura


try this:

using (var ctx = new FbTestModel())
{
var x = ctx.Database.SqlQuery("select int_field from test where 
int_field = @start", 10);
var i = x.SingleOrDefault();
}

raises the error:
Must declare the variable '@start'

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. http://sdm.link/zohodev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [FB-Tracker] Created: (DNET-689) Commit on .NET Data provider throws NullReferenceException.

[Christian B (JIRA)]

Commit on .NET Data provider throws NullReferenceException.
---

 Key: DNET-689
 URL: http://tracker.firebirdsql.org/browse/DNET-689
 Project: .NET Data provider
  Issue Type: Bug
  Components: ADO.NET Provider
Affects Versions: 4.10.0.0
 Environment: Server: Windows 2012 R2 x64
Application: .Net Framework 4.5, Firebird .NET Provider 4.10.0.0, EF 6.0.0.0
Reporter: Christian B
Assignee: Jiri Cincura


Sometimes following error occurs, when we try to executing a procedure on 
database like this:  db.Database.ExecuteSqlCommand("execute procedure...")

An error was reported while committing a database transaction but it could not 
be determined whether the transaction succeeded or failed on the database 
server. See the inner exception and 
http://go.microsoft.com/fwlink/?LinkId=313468 for more information. 
System.Data.Entity.Infrastructure.CommitFailedException CommitFailedException 
System.Data.Entity.Infrastructure.CommitFailedException: An error was reported 
while committing a database transaction but it could not be determined whether 
the transaction succeeded or failed on the database server. See the inner 
exception and http://go.microsoft.com/fwlink/?LinkId=313468 for more 
information. ---> System.NullReferenceException: Object reference not set to an 
instance of an object.
   at FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.Commit() in 
C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsTransaction.cs:line
 172
   at FirebirdSql.Data.FirebirdClient.FbTransaction.Commit() in 
C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbTransaction.cs:line
 142
   at 
System.Data.Entity.Infrastructure.Interception.DbTransactionDispatcher.b__c(DbTransaction
 t, DbTransactionInterceptionContext c)
   at 
System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget
 target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 
executing, Action`3 executed)
   --- End of inner exception stack trace ---
   at 
System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget
 target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 
executing, Action`3 executed)
   at 
System.Data.Entity.Infrastructure.Interception.DbTransactionDispatcher.Commit(DbTransaction
 transaction, DbInterceptionContext interceptionContext)
   at System.Data.Entity.Core.EntityClient.EntityTransaction.Commit()
   at 
System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 
func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, 
Boolean releaseConnectionOnSuccess)
   at 
System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass59.b__57()
   at 
System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1
 operation)
   at 
System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior
 transactionalBehavior, String commandText, Object[] parameters)
   at 
System.Data.Entity.Internal.InternalContext.ExecuteSqlCommand(TransactionalBehavior
 transactionalBehavior, String sql, Object[] parameters)
   at System.Data.Entity.Database.ExecuteSqlCommand(TransactionalBehavior 
transactionalBehavior, String sql, Object[] parameters)
   at System.Data.Entity.Database.ExecuteSqlCommand(String sql, Object[] 
parameters)
System.Action`3[TInterceptor,TTarget,TInterceptionContext], 
System.Action`3[TInterceptor,TTarget,TInterceptionContext])at 
System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget
 target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 
executing, Action`3 executed)
   at 
System.Data.Entity.Infrastructure.Interception.DbTransactionDispatcher.Commit(DbTransaction
 transaction, DbInterceptionContext interceptionContext)
   at System.Data.Entity.Core.EntityClient.EntityTransaction.Commit()
   at 
System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 
func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, 
Boolean releaseConnectionOnSuccess)
   at 
System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass59.b__57()
   at 
System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1
 operation)
   at 
System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior
 transactionalBehavior, String commandText, Object[] parameters)
   at 
System.Data.Entity.Internal.InternalContext.ExecuteSqlCommand(TransactionalBehavior
 transactionalBehavior, String sql, Object[] parameters)
   at