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
0 answers

Type "OracleDbType.Int64" cannot be used in PL/SQL table parameter - devart dotConnect Express for Oracle

I am working on a project where I want to use int64 as return type for the elements in an array returned by a PL/SQL procedure. The procedure is invoked using the dotConnect Express for Oracle data provider version 8.5.521 (downloaded from nuget).…
Lasse Christiansen
  • 10,205
  • 7
  • 50
  • 79
1
vote
1 answer

Does App.config (or ApplicationName.exe.config) work in mono?

I'm trying to get EntityFramework 6 with dotConnect for Oracle working on Mono. I have also all app configuration defined in userSettings section. First thing I noticed is that my app has always default configuration, then I tried to make…
smokeing
  • 259
  • 1
  • 3
  • 13
1
vote
1 answer

Passing parameters with apostrophes and wildcards from C++ to SQL

Afternoon all I've been working on a dll extension for an application, it's a report on customer activity and the first section is a user search to lookup the customer. The query itself works fine but when I tried to make it SQL injection proof by…
1
vote
1 answer

Why @User.IsInRole not working?

I'm using licensed Devart dotConnect product to connect to a PostgreSql database in my ASP.NET MVC5 project. I have problem with Devart Rolemanager. I installed Dotconnect PostgreSql with folowing this tutorial…
Husni Salax
  • 1,968
  • 1
  • 19
  • 29
1
vote
1 answer

Entity Framework 6.1.3 code first fluent mappings compatible database on mono

I have a Asp.Net webapi 2 system that works with sql server. I developed it using entity fraework 6.1.3 code first data models and fluent mappings with the typical workflow of add-migration/update-database. I love it. I have a need to create the…
1
vote
1 answer

ToListAsync with DevArt dotConnect seems to be executing synchronously?

I have code that uses devArt's dotConnect to connect to an Oracle database. It basically looks like this: using (var context = new MyContext(myConnectionString) { var data = (some lync query).ToListAsync(); var data2 = (some lync…
jeff.eynon
  • 1,296
  • 3
  • 11
  • 29
1
vote
1 answer

"Login failed for user" trying to connect to SQL Server 2012

I'm trying to get acces to a remote SQL Server, using SDAC. (in fact I have to get access to the remote DB from android application) What I've done to set up is here The configuration string of the TMSConnection is: Password=mysaPwd;Data…
Gianluca Colombo
  • 717
  • 17
  • 38
1
vote
1 answer

Oracle Database Provider and dotConnect for Oracle -> how to make them generate SQL compatible with the Oracle version they are connected with?

I'm using .NET Entity Framework with Oracle. There are two main providers for Oracle database: one is the official release from Oracle ("ODP" - Oracle Database Provider) and another is the "Devart dotConnect for Oracle". In the documentation of both…
user1389591
1
vote
1 answer

"The files are identical" don't pop up at all even the files are identical in Visual Studio

When I click on a file in Visual Studio I don't get dialog that informs me that "The following files are identical:". It opens immediately compare tool. Some time ago, I clicked on "Always Open" button on that dialog, and from then onwards VS…
1
vote
0 answers

Spatial Data Issue for Client Code Generation OpenRIA

I have a Property in Entity Framework 6 Entity Class [EdmScalarPropertyAttribute()] [DataMemberAttribute()] //[JsonConverter(typeof(DbGeometryConverter))] public global::System.Data.Entity.Spatial.DbGeometry Geom { get …
akirti
  • 179
  • 2
  • 15
1
vote
0 answers

PostgreSQL Service unexpectedly closing

using PostgreSQL 9.2 on Windows Xp(RAM 4GB) sometimes the Database service is closing unexpectedly. am new in PostgreSQL Database, So i cannot figure out the reason behind it, can any one help me ?! log 1 log 2 Current Backend Access…
user3814846
1
vote
1 answer

dotconnect for postgres - Unknown parameter direction

I have problem with PgSqlCommandBuilder.DeriveParameters function. Sometimes it throws an exception “Unknown parameter direction.” without any visible reason. Problem occurs quite rarely. When I get a first exception, it throws always for all…
smolam
  • 21
  • 3
1
vote
1 answer

Where is streamed blob data saved until commit?

From the devart docs it says that: Note that writing data to OracleLob object results in immediate data transfer to server. But it doesn't mention how this actually works. For instance, in the following example (from the docs): public void…
Lasse Christiansen
  • 10,205
  • 7
  • 50
  • 79
1
vote
0 answers

Can RIA Service Project And client Silverlight application be separated?

So far all Silverlight RIA example, Tutorial I saw is they Write RIA Domain Services in projectname.Web and Give the WCF_RIA Project reference in Projectname Project which have silverlight code. Now My question is can my Client take reference of…
1
vote
1 answer

"Column not allowed here" in EF6 with TPH and Devart Oracle

When creating my DB schema with EF, Devart dotConnect generates the following SQL for my TPH class: CREATE TABLE "Types" ( ID NUMBER(10) NOT NULL, "Name" NVARCHAR2(50) NULL, "Discriminator" NVARCHAR2(128) DEFAULT (Undefined) NULL, …
hoekki
  • 228
  • 1
  • 11