Check RAID rebuild status of R710?

Question

How do I use methods such as DatePart or TruncateTime, etc. in Entity Framework Core 3.0? In Entity Framework 6.3.0 it was possible to call for example

DbFunctions.TruncateTime

but now there is no such method. I found that something like this can be done with the code shown below, but I didn't manage to get it working since the constructor of the SqlFragmentExpression is internal:

public int? DatePart(string datePartArg, DateTime? date) => throw new Exception();

public void OnModelCreating(DbModelBuilder modelBuilder) {
    var methodInfo = typeof(DbContext).GetRuntimeMethod(nameof(DatePart), new[] { typeof(string), typeof(DateTime) });
    modelBuilder
        .HasDbFunction(methodInfo)
        .HasTranslation(args => new SqlFunctionExpression(nameof(DatePart), typeof(int?), new[]
                {
                        new SqlFragmentExpression(args.ToArray()[0].ToString()),
                        args.ToArray()[1]
                }));
}

Here is a simple LINQ query I'm trying to get working:

context.Books.Any(x => DbFunctions.TruncateTime(x.date) == data.Date);

Is there some other way to accomplish that, or is there at least someone working on adding these features?

---

Edit 1

To clarify my problem - I need to group the rows by the result of DatePart afterward.

Solution 1

I found I could check the status with MegaCli as ewwhite mentioned:

MegaCli64 -PDRbld -ShowProg -PhysDrv [CONTROLLER:DRIVE] -aAll

Solution 2

If you have Dell's OpenManage software installed, you can also use omreport storage vdisk to provide a summary of all virtual disks (which should include rebuild progress).

Technically megaCLI isn't considered a "supported" tool by Dell (even though I think it's probably what's being used on the back-end by OMSA), but it's still a VERY useful tool when dealing w/ PERC controllers.

Comments

[ewwhite]

Probably some magic incantation using the MegaCLI command.

[ewwhite]

PERC controllers are usually LSI devices, so MegaCLI will work for your PowerEdge R710.

[Daniel Schmid]

Are data.Date and Books.date of different types? And the date column of the Book table in the database is not of type DATE? Would it help to set the SQL data type of the column on the model property to "DATE"?. It's not obvious to me why the TruncateTime() is needed here.

[Daniel Schmid]

See Comments and answers in: stackoverflow.com/questions/40758784/…

[Admin]

Hey, thank you for your answer. Sorry, my question might be a little bit unclear, so I'm editing it. The shown code was just a small query to test this, but what I really need is to user GroupBy on the DatePart.