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
4
votes
2 answers

Select Single Parent with Multiple Children into Custom Entity

I am trying to produce a custom entity using a select statement that involves tables a parent/child relation (1:n). I made an attempt to group the objects selected, but I am having trouble coming up with a solution. My data would be this…
kryptonkal
  • 874
  • 8
  • 23
4
votes
1 answer

Sort a Delphi dataset

I have an unsorted dataset (a TMSQuery from Devart) that I cannot sort using ORDER BY because I manipulate the records after opening the query so the order given by "ORDER BY" is lost. I don't want to rewrite the whole logic so I should find a way…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249
4
votes
2 answers

C# integration test run per connection string

We have an application that uses Entity Code First and we have added Devart for Oracle support. We have a series of integration tests that run through Visual Studio test runner that cover seed data testing. We would like to be able to run these…
Jamie Young
  • 41
  • 2
4
votes
1 answer

Entity Framework complaining about required fields when saveChanges even if valid data are setted

I'm using Entity Framework (DbContext with database first) with MVC. When user save from a form, I have a condition in the controller that send the entity to the update of insert method depending of some internal flag of mine. When sending entity to…
Etienne Desgagné
  • 3,102
  • 1
  • 29
  • 36
3
votes
1 answer

Entity Framework EDMX file size disproportional big (many megabytes)

This morning I used the Entity Framework designer to update my model from the database to select a single table. Out of nothing thousands of lines of XML were added to storage model of the EDMX file which had grown from 244 KB to over 14 MB.…
Steven
  • 166,672
  • 24
  • 332
  • 435
3
votes
0 answers

Unknown column in field list error using Complex types in EF Core 3

For context, I'm in the process of migrating our EF6 Db Context to EF Core 3. Why EF Core 3 only? Currently we're not able to upgrade to the latest EF Core version because of project constraints. We're still using .NET Framework 4.5.6, we're slowly…
Aj Grandeza
  • 75
  • 1
  • 8
3
votes
2 answers

devart web api call procedure with entity framework context

I have and web api and I use entity framework but for procedure I am calling procedure like code below public List GetListAtama() { List result = new List(); try { …
mr. pc_coder
  • 16,412
  • 3
  • 32
  • 54
3
votes
2 answers

How can I determine the database usage of a SQLite database?

In SQLite the size of the database file is the overall size of the database, but this is not necessarily a correct indication of the actual space used. If data is deleted, the freed space is not returned to the operating system. One has to execute…
Elan
  • 6,084
  • 12
  • 64
  • 84
3
votes
1 answer

EF Model First and Database First Alternatives?

Since MSFT has officially abandoned Model First and Database First, does anyone have alternative suggestions for this functionality? One I am considering is DevArt Entity Developer. Can anyone else suggest any other alternatives I should consider? A…
Dave
  • 1,822
  • 2
  • 27
  • 36
3
votes
1 answer

Error "column c.CreatedOn does not exist..." in PostgreSQL logs during code first context initialization using the Devart dotConnect provider

I'm getting the following error in my PostgresSQL logs whenever my context is initialized: 2014-06-03 09:51:25 PDT ERROR: column c.CreatedOn does not exist at character 10 2014-06-03 09:51:25 PDT STATEMENT: SELECT c."CreatedOn" FROM…
Chris
  • 1,533
  • 2
  • 17
  • 33
3
votes
1 answer

What are the differences between using EDMX or EDML for entity design?

Two quick quesitons: Benefits of using EDMLs vs. EDMXs - when would you choose to use one over the other DevArt's Entity Developer vs. Visual Studio's Entity Designer - I know this part of the question may be a bit subjective, so I would rather ask…
Robert Koritnik
  • 103,639
  • 52
  • 277
  • 404
3
votes
3 answers

How Does One Dynamically Load x86/x64 Version of SQLite3.DLL Based On Client Architecture?

I'm trying to dynamically load the appropriate x86/x64 version of the SQLite3.DLL at runtime for use with the Devart.SQLite.DLL. I don't have control over installing the appropriate version of the DLL to the application root beforehand, so I must…
dthagard
  • 823
  • 7
  • 23
3
votes
1 answer

Firebird error error code = -206 Column unknown

I use IBDac with Delphi to connect to Firebir db and suddenly when I tried to run the software I got this error Dynamic SQL ErrorSQL error code = -206 Column unknown table1.MyField_ID At line 6, column 18 the error show up when I try to open…
zac
  • 4,495
  • 15
  • 62
  • 127
3
votes
2 answers

StoreGeneratedPattern not working with DevArt Entity Framework?

I wrote a simple test program which will access the default HR model on an Oracle Express in direct mode using DevArt dotConnect for Oracle v. 6.8.0.350: using (var ctx = new HREntities()) { var locNew = new LOCATION(); locNew.CITY =…
Alexander Schmidt
  • 5,631
  • 4
  • 39
  • 79
2
votes
4 answers

Is it possible to take a snapshot of a dataset?

IN my application I use DBAware components exclusively (except a few places). I have a scenario in which I create a Master dataset (e.g. customer), detail dataset (e.g. Orders), subdetail dataset (e.g. order items). TYpically I allow users to make…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249
1 2
3
…
25 26