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
2
votes
1 answer

Devart dotConnect For Oracle and Enterprise Library Custom Provider Mappings

I'm trying to get a simple proof-of-concept working using the trial of Devart's dotConnect for Oracle because we currently use the .Net framework OracleClient (due to be deprecated) but we also have a requirement to connect without the need for the…
Steve Pettifer
  • 1,975
  • 1
  • 19
  • 34
1
vote
3 answers

What format does Oracle expect for dates?

With the following C# code (using devArt's dotConnect for Oracle components): OracleParameter pRes = new OracleParameter("C_REF", OracleDbType.Cursor); pRes.Direction =…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
1
vote
3 answers

Cross Database Entity Framework Support

I am looking to use Entity framework as database layer in my application, but I found that it didn't support oracle database and I will need to use third party provider for this purpose. However I want to build database layer support multiple…
kaito ked
  • 175
  • 1
  • 1
  • 15
1
vote
0 answers

Adding Relationships between views in Devart entity framework

I want to have a relation between views in EF. I am following this post to modify it in the xml file. http://smehrozalam.wordpress.com/2009/08/12/entity-framework-creating-a-model-using-views-instead-of-tables/. I am getting error, Custom tool…
genericuser
  • 1,430
  • 4
  • 22
  • 40
1
vote
2 answers

Is Close on database connection calling here?

I got this code: try { using (OracleConnection c = new OracleConnection(globalDict[byAlias(connAlias)].connString)) { c.Open(); using (OracleCommand recordExistentQuery = new OracleCommand("regular.IsExistent", c)) …
kseen
  • 359
  • 8
  • 56
  • 104
1
vote
3 answers

Some tricky quick way to validate oracle db connection

My WCF service need to check is connection available now and can we work with it. We have many remote dbs. Their connection are weird sometimes and can't be used to query data or smth else. So, for example this is regular connection string…
kseen
  • 359
  • 8
  • 56
  • 104
1
vote
1 answer

Is there any way to set the TableAttribute at runtime, OR any way to do LINQ type switching at runtime?

I asked the question this way because I can imagine that there's a potentially easy but Devart specific solution, but maybe also a very general solution for any similar situation. I'm using Devart LINQ To Oracle, and generally you create a class…
Joshua Frank
  • 13,120
  • 11
  • 46
  • 95
1
vote
1 answer

Compiled queries in Linq to Devart Entity Framework

For Compiled Queries, In LINQ to Object Entity FrameWork basically it allows the queries to compile at one time and then it can be re-used without compiling another time. For Example: using System.Data.Objects; public static Func
online_user
  • 45
  • 1
  • 7
1
vote
2 answers

Telerik's OpenAccess ORM and DevArt's dotConnect for Oracle

Has anyone tried to connect to an Oracle DB using DevArt's dotConnect data provider among with OpenAccess ? OpenAccess works excellent with Oracle.DataAccess.Client, but how about dotConnect? Is it possible? Thanks!
Teslo.
  • 471
  • 2
  • 9
  • 22
1
vote
1 answer

Deploying Devart EF Odata app to a Server - cannot find Framework Data Provider

I followed the simple tutorial @ http://www.devart.com/dotconnect/oracle/articles/Tutorial_EF.html (Which works perfectly, btw) combined with http://www.hanselman.com/blog/CreatingAnODataAPIForStackOverflowIncludingXMLAndJSONIn30Minutes.aspx for…
saunderl
  • 1,618
  • 2
  • 16
  • 31
1
vote
2 answers

How to pass NULL value from Unidac Query component in Delphi?

When I am using StoredProc component in Delphi using ParamByname('ParamName').Clear I'm able to send NULL value. But how can I pass NULL value when using a Query component? with Query do begin SQL.ADD('exec…
SSE
  • 445
  • 2
  • 10
  • 29
1
vote
2 answers

EFCore 7 and Devart.Data.MySql.EFcore 9.1.134.7 Weird Query Syntax Errors

Having a very difficult time determining the root cause of this bug, not sure if its a devart connector issue or what. I have two queries that are simply generating a list of data and outputting in a table. When the data is outputted in a table you…
99823
  • 2,407
  • 7
  • 38
  • 60
1
vote
1 answer

Oracle not using index, Entity Framework & Devart DotConnect for oracle

The table in question has ~30mio records. Using Entity Framework I write a LINQ Query like this: dbContext.MyTable.FirstOrDefault(t => t.Col3 == "BQJCRHHNABKAKU-KBQPJGBKSA-N"); Devart DotConnect for Oracle generates…
Marc Wittke
  • 2,991
  • 2
  • 30
  • 45
1
vote
1 answer

Devart.Data.MySQL Entity Provider

I'm having an issue getting Devart.Data.MySQL set up as an Entity Provider. What I have reached so far is this App.config: https://paste.mozilla.org/Q81ctALe But all that does is throw this exception: System.InvalidOperationException: 'The Entity…
Martin
  • 63
  • 1
  • 3
1
vote
1 answer

Migrating data in an database created with EF code first (devart connector) to EFCore code first (sqlite)

The EFCore documentation is very specific on what to do, to migrated an EF based codebase to EFCore https://learn.microsoft.com/en-us/ef/efcore-and-ef6/porting/ . However, I could not find advice on how to bring the data stored in an sqlite database…
MatBab
  • 11
  • 1
1 2 3
…
25 26