Stack Overflow
Stack Overflow

Questions tagged [devart]

Devart is a software development company specializing in native data access solutions, tools and database tools for the most popular databases, including MS SQL Server, MySQL, Oracle, PostgreSQL, InterBase, Firebird, and SQLite.

Devart is a software development company specializing in native data access solutions, tools and database tools for the most popular databases, including:

  • MS SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • InterBase
  • Firebird
  • SQLite.

We try to provide high-end products to let you have the fastest data access and the broadest database support.

386 questions
1
vote
1 answer

Cannot bind to event via reflection on VS2015

I've a piece of code that fills a database table from a DataTable using a DbDataAdapter. The DbDataAdapter is created via DbProviderFactory.CreateDataAdapter method, where DbProviderFactory is provided by Devart dotConnect. We use Devart's drivers…
Teejay
  • 7,210
  • 10
  • 45
  • 76
1
vote
1 answer

devart oracle 9.3- entity framework 7 ( or core 1) Mapping can't recognize decimal at visual studio 2017

I am working on a .Net Core class library project.I use Devart entity framework core to connect oracle database. I use devart's oracle mapping methods at link http://blog.devart.com/entity-framework-core-1-entity-framework-7-support.html I can get…
mfg
  • 23
  • 7
1
vote
0 answers

Delphi failover needs to reconnect to the database

I was trying to implement the failover available here http://www.andreanolanusse.com/en/implementing-failover-and-load-balancing-in-datasnap-2010/ but if I add a database connection and kill the first server, when I use some of the remote functions…
Lucas Steffen
  • 1,244
  • 2
  • 10
  • 22
1
vote
1 answer

OutOfMemoryException with SQL Select

I'm currently analyzing an OutOfMemoryException occuring in our application when doing a SQL select. Environment: - x86 .NET 4.6.1 application (No possibility to use it as x64) - Devart.Data 5.0.1491.0 - Devart.Data.Oracle 9.1.67.0 - Entity…
Philippe
  • 1,949
  • 4
  • 31
  • 57
1
vote
1 answer

Execute SQL command with parameter using Devart EF Drivers for Oracle

I am trying to delete records from an Oracle table before inserting new ones using a sql command and a parameter because the value comes from the browser. This is the code: var tableName = ""; context.Database.ExecuteSqlCommand("DELETE…
samneric
  • 3,038
  • 2
  • 28
  • 31
1
vote
3 answers

Change Schema Name at Runtime in data context

So, I'm using dotConnect for Oracle. I used the template and wizard to create a model of the database (Database first approach). We have multiple databases that a single application needs to reference and unfortunately the schema naming which…
Felix Castor
  • 1,598
  • 1
  • 18
  • 39
1
vote
1 answer

Intercepting LINQ to SQL results

I'm attempting to capture query results from linq expressions sent to a DataContext (Devart.Data.Linq). I am able to record the queries by making use of the Log property but have not yet found a way to intercept the IQueryable results. The…
charliemango
  • 85
  • 5
1
vote
2 answers

Devart dotConnect Express for Oracle Connection with service name

I have the version 9.1.131.0. I want to connect to a Oracle 12 DB with a Service Name. I have the login, pw, server, but it seems i can't add a service name or port to OracleConnectionStringBuilder. How do i connect to my db with a service name? I…
k4yaman
  • 475
  • 8
  • 20
1
vote
1 answer

Entity Data Model Wizard error (MVC)

I am getting an error when trying to add postgres at the prompt asking what version of entity framework I would like to use I get the following error: Your project references the latest version of Entity Framework; however, an Entity Framework 3…
user6740100
1
vote
0 answers

How to map oracle type number(10) to Int32 with ODP.NET and DataSet

I'm using DataSets and DataTables with ODP.NET Oracle provider and I want to map oracle columns with type NUMBER(10) to Int32 instead of Int64. I found how to do it for EDM, but seems like this solution doesn't work for DataSets and DataTables…
Eugene Filimonov
  • 11
  • 2
1
vote
1 answer

Oracle dbms_alert.signal firing once for multiple actions

I have a trigger in Oracle that calls sys.dbms_alert.signal. A DevArt OracleAlerter receives these alerts in a self-hosted service. However, I am finding that even for multiple deletes/updates/inserts the OracleAlerter is receiving an alert for…
David Brower
  • 2,888
  • 2
  • 25
  • 31
1
vote
2 answers

"Nullable object must have a value" exception after checking for null on a non-primitive/non-struct object

I'm getting Nullable object must have a value after checking for null on a regular object, after a null check. I've found various questions, mostly regarding linq-to-sql, having the same problem but always with nullable primitive types (as in bool?…
Steffen Winkler
  • 2,805
  • 2
  • 35
  • 58
1
vote
1 answer

*Not* getting ChangeConflictException using Devart

I'm investigating an intermittent occurrence of Devart.Data.Linq.ChangeConflictException: Row not found or changed. I've been reading the Devart article on concurrency conflicts, and just as a starting point I am trying to reproduce a concurrency…
Ian
  • 1,475
  • 2
  • 15
  • 31
1
vote
0 answers

Working with a t4 template to determine the type of a property

I am working with the templates provided by Devart in their Entity Developer product. I'm really not sure if these are pure T4 templates , but they certainly appear to be close. What I am trying to do is have the partial classes created for my…
Dom Sinclair
  • 2,458
  • 1
  • 30
  • 47
1
vote
1 answer

SQLite auto increment starts with 0 and then the process is terminated

I am trying to use SQLite in WinForms. So I created a table named Artist and it has 2 columns named ArtistId, Name. ArtistId's properties are: INTEGER PRIMARY AUTOINCREMENT. In the foreach loop, if I give manually value, there is no problem. …
user1372430
1 2 3
…
25 26