Devart Forums

NSY738

Hi

I have a table after dump around 5gb. is it possible auto split to 500mb per file via devart dump?

if no, have any suggestion to achieve this requirement?

thank you

NSY738

I have a problem.
I need to use the distance and IsWithinDistance functions in entity framework core 5.

But when I write this,

var result = dbContext.Addresses.Where( u => u.Geometry.IsWithinDistance(geometry, km)).Select(u => u.Id).ToList();

I get an error.

The LINQ expression 'DbSet<Address>()
.Where(o => o.Geometry.IsWithinDistance(
geom: __geometry_0,
distance: __p_1))' could not be translated. Additional information: Translation of method 'NetTopologySuite.Geometries.Geometry.IsWithinDistance' failed. If this method can be mapped to your custom function, see https://go.microsoft.com/fwlink/?linkid=2132413 for more information. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

Can you give me some advice on how to solve this problem.

Thank you

NSY738

HI

I facing a problem it is related to Timestamp.

If i using following code

Code: Select all


using (ApplicationDbContext db = new ApplicationDbContext())
{
	db.Configuration.LazyLoadingEnabled = false;
	db.Configuration.AutoDetectChangesEnabled = false;

	int Oid = dbObj.Id;
	var dbObjUpd = db.OMTrans.Where(u => u.Id == Oid).FirstOrDefault();

	dbObjUpd.Oid = int.Parse(returnedString);
	dbObjUpd.Mupd_DateTime = DateTime.Now;
	db.Entry(dbObjUpd).State = System.Data.Entity.EntityState.Modified;
	db.SaveChanges();
}

then i will get an error likes this.
"The 'RowVersion' property on 'OMTran' could not be set to a 'System.DateTime' value. You must set this property to a non-null value of type 'System.Byte[]'. "

but if i using below code then no problem.

Code: Select all

using (ApplicationDbContext db = new ApplicationDbContext())
{
	db.Configuration.LazyLoadingEnabled = false;
	db.Configuration.AutoDetectChangesEnabled = false;

	List<int> ListObjInt = new List<int>();
	ListObjInt.Add(dbObj.Id);
	var dbObjUpd = db.OMTrans.Where(u => ListObjInt.Contains(u.Id)).FirstOrDefault();

	dbObjUpd.Oid = int.Parse(returnedString);
	dbObjUpd.Mupd_DateTime = DateTime.Now;
	db.Entry(dbObjUpd).State = System.Data.Entity.EntityState.Modified;
	db.SaveChanges();
}

my omtran class

Code: Select all

 [Table("OMTran")]
    public partial class OMTran 
    {
        public OMTran()
        { 

        }

        [Key] 
        [Column("Id", TypeName = "int")]
        public int Id { get; set; }

        [Display(Name = "Oid")]
        [Column("Oid", TypeName = "int")]
        public int? Oid { get; set; }

        [Required]
        [Column("CompanyId", TypeName = "int")] 
        public int CompanyId { get; set; }

        [Required]
        [Column("StoreId", TypeName = "int")] 
        public int StoreId { get; set; }

        [Required]
        [Column("OMDocId", TypeName = "int")] 
        public int OMDocId { get; set; }
        [ForeignKey("OMDocId")]
        public virtual OMDoc OMDoc { get; set; } 
 

        [Column("Lupd_DateTime", TypeName = "datetime")]
        public DateTime Lupd_DateTime { get; set; }

        [Column("Lupd_UserId", TypeName = "varchar")]
        [StringLength(255)]
        public string Lupd_UserId { get; set; }

        [Column("Lupd_Prog", TypeName = "varchar")]
        [StringLength(50)]
        public string Lupd_Prog { get; set; } 

        [Timestamp]
        public byte[] RowVersion { get; set; }
         
        public ICollection<OMLot> OMLots { get; set; }

    }

is my class problem? or it is standard?

and how to use isTimestamp() method?

NSY738

HI

I follow guide on this page. http://www.devart.com/dotconnect/mysql/ ... lDump.html

now i can backup the database. but when i try to restore the database it will show
Table 'xxxx.v_omdoc' doesn't exist SQL.sql 8152 760

After i checked the problem is sequence of view in the file.

Have any method i can skip the error and continue apply?

Thank you

NSY738

HI

Thank you. the problem is because i use BigInt as key. after i change to integer then problem solved

NSY738

HI

I not sure what is the problem to cause the below error.
Hope someone here can help me on this.

Server Error in '/' Application.

The 'RowVersion' property on 'ScheduleTime' could not be set to a 'System.DateTime' value. You must set this property to a non-null value of type 'System.Byte[]'.

this problem normally occur when i using LINQ with OrderBy

Code: Select all

   List<ScheduleTime> ListScheduleTime = db.ScheduleTimes.Where(u => u.ScheduleId == Id 
                                                                    && u.BeginDay == cd.Id). 
                                                                    OrderBy(u => u.Id).ToList();

Is it not allow to use order by when select?

Thank You For HELP.

Devart Forums

Search found 6 matches

Dump single table data to multiple files.

Distance and IsWithinDistance

Question on RowVersion TImestamp

MySQL DUMP View Sequence

Re: You must set this property to a non-null value of type 'System.Byte[]'.

You must set this property to a non-null value of type 'System.Byte[]'.