Devart Forums

dqminh

I've checked again, and it work. Thanks.

dqminh

Shalex wrote:We have put the ORDER BY clause in the right place and sent you the fixed Devart.Data.Oracle.Web.dll assembly by e-mail.

Sorry, today I check the assembly that you sent, and do as your guide, but the error in the web.config (before replace your assembly, no problem):

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Exception has been thrown by the target of an invocation.

Line 6:

dqminh

Hi,

The membership query:

Code: Select all

MembershipUserCollection users = prv.FindUsersByName(filter, 0, int.MaxValue, out count);

filter is username, and the sql is (from monitor)

Code: Select all

SELECT username, password, u.userid, email, passwordquestion, passwordanswer, comments, isapproved, islockedout, creationdate, lastlogindate, lastactivitydate, lastpasswordchangeddate, lastlockoutdate FROM aspnet_membership m, aspnet_users u WHERE u.userid = m.userid AND LOWER(u.applicationname) = :applicationname order by username AND LOWER(username) LIKE :username

Please fix it!

dqminh

Zero-G. wrote:And when will the BETA2 become Finished?

You enlarge your BETA Times enorm. How should a productivy environment work with your product? - The old, bought version is not working and you don't update it with critical updates....

I am really disappointed and I have to think about a change of your products. - As you know, I am waiting since January of a working version.

This isn't a good ad for your company!

I agree. Now I have to face with problem from our customer. They claim about our service, but it because of your fault.

You must release the next build soon, or tell us how to extend the time trial.

dqminh

Sorry because I cannot figure the problem. But I found the same problem with devart tool for vs 2008: sometime when I open the table in vs 2008, edit the data and update, the devart database developer tools say: Update operation affected 0 records due to possible concurrency violation, very similar with the bug in linq. In this case, if I close the edit window, re-open and edit again, it run ok.

dqminh

Ok, one question and one bug:

1, I download the beta, so I have not the license? Because I login to customer area, there is not beta version.

2, Bug (affect with 5.0.22 and 5.20 beta)

If we have a table, and in the column Name it allow null. Fist, we insert some item (Name still null). Second, query the item with Name is null -> ok. Third, update ANY row which has at least one column has null value with new value -> error.

Code: Select all

var db = new PartDataContext();

gv1.DataSource = db.Accessories.Where(p => p.VietnamName == null);
gv1.DataBind(); // ok, so many item

var o = db.Accessories.Single(p => p.AccessoryId == 41);
o.VietnamName = "abc";
db.SubmitChanges(); // DB concurrency violation

dqminh

Thank you. I see your information about new beta version of dotConnect. Is it fix the bug in this topic?

dqminh

Sorry, I still cannot find. Could you show me the example that demo the transaction with LINQ? Thanks.

dqminh

Hi, is dotConnect support Transaction? I cannot find it.

dqminh

Ok, and another bug

If we have a query (Q1) that return a list of object, and in object result has a property that is a result of another query (Q2), then if in Q2 has more than one where condition, the devart component throw the exception (a bug).

OK:

Code: Select all

var query = from h in db.OrderHeaders
where (h.Status == OrderStatus.OrderConfirmed || h.Status == OrderStatus.OrderSent) && h.DealerCode == UserHelper.DealerCode
orderby h.OrderDate
select new
{
	h.OrderHeaderId,
	h.OrderDate,
	Items = from d in db.OrderDetails
	        join p in db.Parts on d.PartCode equals p.PartCode
	        where d.OrderHeaderId == h.OrderHeaderId // one condition
	        select new
	        {
	            d.PartCode,
	            d.OrderQuantity
	        },
	Total = (from d in db.OrderDetails
			 where d.OrderHeaderId == h.OrderHeaderId
			 select d.QuotationQuantity * d.UnitPrice).Sum()
};

NOT OK:

Code: Select all

var query = from h in db.OrderHeaders
where (h.Status == OrderStatus.OrderConfirmed || h.Status == OrderStatus.OrderSent) && h.DealerCode == UserHelper.DealerCode
orderby h.OrderDate
select new
{
	h.OrderHeaderId,
	h.OrderDate,
	Items = from d in db.OrderDetails
	        join p in db.Parts on d.PartCode equals p.PartCode
	        where d.OrderHeaderId == h.OrderHeaderId && p.DatabaseCode == "HTF" // two conditions
	        select new
	        {
	            d.PartCode,
	            d.OrderQuantity
	        },
	Total = (from d in db.OrderDetails
			 where d.OrderHeaderId == h.OrderHeaderId
			 select d.QuotationQuantity * d.UnitPrice).Sum()
};

dqminh

And another problem: dotConnect current not support compare DateTime? with null (long? with null is work)

dqminh

And another bug: in the group by expression, if select only field, that ok, but if add the aggregate, the sql command is not valid:

OK:

Code: Select all

var query = db.OrderDetails
               .GroupBy(p => p.PartCode)
               .Select(g => new InShortSupplier()
                   {
                       PartCode = g.Key
                   }
               );

Error:

Code: Select all

var query = db.OrderDetails
               .GroupBy(p => p.PartCode)
               .Select(g => new InShortSupplier()
                   {
                       PartCode = g.Key,
                       TotalOrder = g.Sum(p => p.OrderQuantity)
                   }
               );

dqminh

Yes, if I use the group by, then after that paging, it error.

Code: Select all

var query = db.OrderDetails
                .GroupBy(p => p.PartCode)
                .Select(g => new InShortSupplier()
                    {
                        PartCode = g.Key  
                    });

return query.Skip(startRowIndex).Take(maximumRows);

Oracle error: ORA-00979: not a GROUP BY expression

The query in dbmonitor:

Execute: SELECT t1."PartCode"
FROM (
SELECT t2.PART_CODE AS "PartCode", ROWNUM AS rnum
FROM VDMS.V2_P_ORDER_DETAIL t2
GROUP BY t2.PART_CODE
) t1
WHERE (t1.rnum > :p0) AND (t1.rnum <= :p1)

I think you must enclose with a new select outside this sql.

dqminh

Ok, thanks so much, it work

dqminh

Hi,

In version 5.0.0.22, still urgent bug:

We have two tables parent and child with relation ship. All parent and child auto generated ID from trigger. Script below:

Code: Select all

CREATE TABLE v2_data_File(
    File_Id       NUMBER(10, 0)     NOT NULL,
    Message_Id    NUMBER(10, 0)     NOT NULL,
    File_Name     NVARCHAR2(128)    NOT NULL,
    Body          LONG RAW          NOT NULL,
    CONSTRAINT v2_PK28 PRIMARY KEY (File_Id)
)
;


CREATE TABLE v2_data_Message(
    Message_Id      NUMBER(10, 0)     NOT NULL,
    Parent_Id       NUMBER(10, 0),
    Body            NVARCHAR2(512)    NOT NULL,
    Created_Date    TIMESTAMP(6)      NOT NULL,
    Created_By      NVARCHAR2(256)    NOT NULL,
    Flag            CHAR(1)           NOT NULL,
    CONSTRAINT v2_PK01 PRIMARY KEY (Message_Id)
)
;

Using Entity developer to gen C# code, with MessageId and FileId both auto generated value, and auto-sync on insert. So when insert entity to database, exception raise:

Code: Select all

BasicDataContext db = new BasicDataContext();
Message msg1 = new Message() { Body = DateTime.Now.ToLongDateString(), CreatedBy = "admin1", CreatedDate = DateTime.Now, Flag = "S" };
Message msg2 = new Message() { Body = DateTime.Now.ToLongDateString(), CreatedBy = "admin2", CreatedDate = DateTime.Now, Flag = "S" };
//db.Messages.InsertAllOnSubmit(new Message[] { msg1, msg2 });
db.Messages.InsertOnSubmit(msg2);
db.SubmitChanges();

File file = new File { Body = new byte[] { 0, 1, 2 }, FileName = "abc", Message = msg2 };
db.Files.InsertOnSubmit(file);
db.SubmitChanges(); // Value of member 'FileId' of an object of type 'File' changed.A member that is computed or generated by the database cannot be changed.

Please check it.

Devart Forums

Search found 28 matches

5.35.57 bug in Membership provinder

Group with paging is error.

New version, but still error.