Devart Forums

DomenicoFormoso

My subscription is about to expire, I wanted to ask you if you are going to come out with a new version compatible with Visual Studio 2022.
The Devart team must tell the truth to its customers that they intend to continue.

DomenicoFormoso

Yes I own the license, problem a solved thanks

DomenicoFormoso

I have the same problem.

DomenicoFormoso

I have this code:

Code: Select all

WegDataContext db = new WegDataContext();
Fornisceforniamo ff = new Fornisceforniamo();
ff=db.Fornisceforniamos.FirstOrDefault(u => u.Idf == _idf && u.Ida == _ida && u.Ids==_ids);
ff.Ida = textIdA.Text;
ff.u = dataAgg.Value;
ff.p = p.Valore(); //my component
ff.Ids = (int)textS.Tag;    
db.SubmitChanges();

(Ids, Ida and Idf They are Entity Key)

at the line: ff.Ids = (int)textS.Tag;
I get this the error: Devart.Data.Linq.ForeignKeyReferenceAlreadyHasValueException.
I read other posts but I can not figure out how to fix this

DomenicoFormoso

Thanks

DomenicoFormoso

My problem is not related to dotConnect but it is component programming.
For the moment I have excluded the data code at designtime.

Code: Select all

 if (!DesignMode)
            {..}

where

Code: Select all

protected bool IsInDesignMode
{
            get
            {
                return DesignMode || LicenseManager.UsageMode == LicenseUsageMode.Designtime;
            }
}

Thanks

DomenicoFormoso

I created a usercontrol (mycontrol1) containing a treeview that shows the data by dbcontext.
It works fine if I use it dynamically (I create it in the form this.control.add(mycontrol1)).
But if I use mycontrol1 at design time I get the error: Connection string "xxx" could not be found in the configuration file.

here is my app.config:

Code: Select all

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <connectionStrings>
        <add name="xxx" connectionString="User Id=xxx;Password=yyy;Host=server;Database=gestio;Persist Security Info=True" />
        <add name="yyy" connectionString="User Id=yyy;Password=yyy;Host=server2;Database=saol3;Persist Security Info=True" />
    </connectionStrings>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />
    </startup>
</configuration>

use dot.connect for mysql ver8.12.1229.0

DomenicoFormoso

Hi I'm new to c # but I come from delphi.
I'm turning my software from delphi to c #, instead of MyDac I use dotConnect mysql.
My job today is to force a value on an autoinc column.
MyDac was good at doing this while dotConnect does not do it.

MyDac (work fine insert new row with manifaturer_id=150)

Code: Select all

   ...
   Q:=TmyQuery.Create(Owner);
   Q.Connection:=ecomm;
   id:=150;
   Q.SQL.Text:='INSERT INTO manufacturer (manufacturer_id, ....) VALUES '+'('+StrToInt(id)+',..
   Q.ExecSQL;
   Q.Close;
   ....

dotConnect (work but insert new row with manifaturer_id = nextvalue)

Code: Select all

   ...
    OC dbx = new OC;
    Manufacturer mani = new Manufacturer();
    int id = 150;
    mani.ManufacturerId = id;
    dbx.Manufacturers.InsertOnSubmit(mani);
    dbx.SubmitChanges();
...

Thanks

Devart Forums

Search found 8 matches

Re: Visual Studio 2022

Re: Licensing issue with .NET 6

Re: Licensing issue with .NET 6

Devart.Data.Linq.ForeignKeyReferenceAlreadyHasValueException

Re: Some value in autoinc

Re: UserControl and Connection String

UserControl and Connection String

Some value in autoinc