|
I know there's one already... Nicely packed inside the Entity Framework 6 package!? 
So if I want to singularize or pluralize (English) words I have to add a package to an old version of an ORM, nice!
It also doesn't work all too well with EF Core.
Because I want to work with language...
The service wasn't added to .NET Core, but luckily someone ported it... Which also implicitly adds it to my EF Core designer messing up my database generation 
Anyone know of a good alternative that has nothing to do with databases?
|
|
|
|
|
|
That looks good, but it does A LOT! 
Certainly worth checking out, thanks 
|
|
|
|
|
Funny - they have a Dasherize method, but they use Hyphenate instead of Hyphenize.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
You could always write your own. It's not like the rules are complicated or anything! 
An Algorithmic Approach to English Pluralization[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote: It's not like the rules are complicated
After all Goose - geese and Mongoose - mongooses, is completely logical.
|
|
|
|
|
The article starts with "the issues..." and "The problem of..."
If you look at the (ported) source code of the EF pluralizer[^] you'll see it's mostly exceptions
It even includes the word "pneumonoultramicroscopicsilicovolcanoconiosis"
|
|
|
|
|
Which the Oxford English Dictionary defines as "an artificial long word said to mean a lung disease caused by inhaling very fine ash and sand dust". 
Although it's probably still easier to pronounce than the name of that Icelandic volcano.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote: Although it's probably still easier to pronounce than the name of that Icelandic volcano.
|
|
|
|
|
Why do you want to use Entity Framework ? - biggest POS I've seen in code ( I know - I should get out more )
"We can't stop here - this is bat country" - Hunter S Thompson - RIP
|
|
|
|
|
Why wouldn't you?
Makes DB connections and queries A LOT easier
|
|
|
|
|
Mmmm...
"We can't stop here - this is bat country" - Hunter S Thompson - RIP
|
|
|
|
|
It took you nearly a month to come up with that answer?
|
|
|
|
|
Hi can anyone help? I've been stuck with this issue for the past 2 days. I'm trying to run asp.net application in visual studio 2019 I've tried changing the port numbers, it doesn't work, it still pops up with the error "unable to connect to web server IIS Express'. I've deleted my vs folder with the config like 100 times, restarted visual studio, did a clean and build, restarted my PC. None of this has worked. I've looked into the list of processes and I can see this port is not being used. I've tried using netstat to find what's using that port no luck. I mean it doesn't make any sense, any ports I tried I get the same "unable to connect to web server iis express error. This is happening to multiple projects in a solution but when I create a new project in a fresh solution, I can run new projects fine. I've also tried visual studio 2017, no luck! So the problem is with these web projects. Someone please help I'm a bit frustrated.
|
|
|
|
|
IS that 5xxxx port in use? Then it should be possible to identify the guilty from the Network tab in Resource Monitor, and you can see which process is the culprit. If there is no trace of port 5xxxx in Resource Monitor, then the error message is wrong, and you must search for other explanations.
My guess is that after an earlier run, the closedown ran into issues so the cleanup wasn't done properly. Maybe there is a stray detached process holding that port (then you'll see it in Resource Monitor), or some table of "ports that I have opened and must remember to close" table wasn't ceared. Both of these would most easily be solved by a controlled shutdown and reboot.
If you have rebooted since the problems arose, to no avail, there may be configuration / state info saved in the registry, application specific ini files etc. Right now, I am fighting a problem in an IDE: Every now and then things lock up. and the only way to unlock it is to delete the entire build directory. Earlier today, I had another problem: When one project setup was corrupted, I wanted to select another one - but the IDE always initialize e.g. directory searches from the settings of the current project, whose values were corrupted. So the selection dialog locked up completely (even after deleting the build directory of the current project), and I couldn't select another one. Fortunately, I found a list of "recently opened projects", and selecting one of those updated the defaults for the project selection dialog, overwriting the corrupted values.
I have no idea about where those corrupted values are stored, and I had to resort to tricks to get them out of the way. You may have to go on a similar hunt . As a last resort, I could have wiped out the entire IDE and reinstalling it from scratch; fortunately I didn't have to do that (reinstallation takes quite some time). Maybe you will end up with having to do that.
|
|
|
|
|
im trying to use Disc utils but i dont see the components
|
|
|
|
|
You don't find them because that's not part of Windows, the .NET Framework, or Visual Studio.
It's a 3rd party component you have to download.
Trying typing "DiscUtils.dll" into Google and you just might find where to get it from.
|
|
|
|
|
i have already a good Programm which shows my database in a Datagridview,
everything is Ok with it, now i would like to add Filter Option to my Datagridview like Excel Filter
i used : AdvanceDatagridview it's an advanced Datagridview with a lot of filter Option,
the problem here, i can not use this datagridview unless i bind it with a Datatable and i also when i did that t found a big problem because in my old code there is Datagridviewrow
and now so i tried to convert Datagridviewrow to datarow to import it in datatable and to use it but it did not work
my Old Code :
<pre> sSQL = "SELECT " &
"ItemID, " &
"PSC_tdItems.OrderID, " &
"ArtikelID, " &
"Menge, " &
"Art, "
"CodeID, " &
MyCommand = New SqlCommand(sSQL, conFF)
drW2P = MyCommand.ExecuteReader
If drW2P.HasRows Then
While drW2P.Read()
nField_ItemID = 0
nField_OrderID = 0
nField_Quantity = 0.0
sField_Art = ""
sField_pscArticleID = ""
sField_CodeID = ""
If Not DBNull.Value.Equals(drW2P("ItemID")) Then
nField_ItemID = Convert.ToInt32(drW2P("ItemID"))
End If
If Not DBNull.Value.Equals(drW2P("OrderID")) Then
nField_OrderID = Convert.ToInt32(drW2P("OrderID"))
End If
If Not DBNull.Value.Equals(drW2P("Menge")) Then
nField_Quantity = Convert.ToDouble(drW2P("Menge").ToString.Replace(".", ""))
End If
If Not DBNull.Value.Equals(drW2P("Art")) Then
sField_Art = drW2P("Art").ToString
End If
If Not DBNull.Value.Equals(drW2P("ArticelNumber")) Then
sField_mspArticleNumber = drW2P("ArticelNumber").ToString
End If
If Not DBNull.Value.Equals(drW2P("CodeID")) Then
sField_CodeID = drW2P("CodeID").ToString
End If
Try
MyRow = New DataGridViewRow
MyRow.CreateCells(dgvW2P)
MyRow.SetValues("0",
imgNotOK.ToBitmap,
nField_ItemID,
nField_OrderID,
nField_Quantity
sField_Art,
sField_pscArticleID
sField_CodeID)
dgvW2P.Rows.Add(MyRow)
Catch ex As Exception
ErrorLogging(True, "Sub FillW2PGrid: Add a line in the grid" & vbCrLf & ex.Message & vbCrLf & "SQL:" & sSQL & vbCrLf & ex.StackTrace.ToString, nErrorLevel_Error)
Finally
If Not MyRow Is Nothing Then
MyRow.Dispose()
MyRow = Nothing
End If
End Try
End While
End If
my new Code :
<pre> sSQL = "SELECT " &
"ItemID, " &
"PSC_tdItems.OrderID, " &
"ArtikelID, " &
"Menge, " &
"Art, "
"CodeID, " &
Dim Dt As New DataTable
Dt.Clear()
Dim cmd As New SqlCommand
If conFF.State = ConnectionState.Open Then
conFF.Close()
End If
conFF.Open()
cmd.Connection = conMspFF
cmd.CommandType = CommandType.Text
cmd.CommandText = (sSQL)
Dim da As New SqlDataAdapter(cmd)
da.Fill(Dt)
bindingSource_data.DataSource = Dt
dgvW2PNEW.DataSource = bindingSource_data
dgvW2PNEW.Refresh()
drW2PNEW = MyCommand.ExecuteReader
' the problem is here : i can not use HasRow with my new Datagridview
<pre> If drW2PNEW.HasRows Then
While drW2PNEW.Read()
nField_ItemID = 0
nField_OrderID = 0
nField_Quantity = 0.0
sField_Art = ""
sField_pscArticleID = ""
sField_CodeID = ""
If Not DBNull.Value.Equals(drW2PNEW("ItemID")) Then
nField_ItemID = Convert.ToInt32(drW2PNEW("ItemID"))
End If
If Not DBNull.Value.Equals(drW2PNEW("OrderID")) Then
nField_OrderID = Convert.ToInt32(drW2PNEW("OrderID"))
End If
If Not DBNull.Value.Equals(drW2PNEW("Menge")) Then
nField_Quantity = Convert.ToDouble(drW2PNEW("Menge").ToString.Replace(".", ""))
End If
If Not DBNull.Value.Equals(drW2PNEW("Art")) Then
sField_Art = drW2PNEW("Art").ToString
End If
If Not DBNull.Value.Equals(drW2PNEW("ArticelNumber")) Then
sField_mspArticleNumber = drW2PNEW("ArticelNumber").ToString
End If
If Not DBNull.Value.Equals(drW2PNEW("CodeID")) Then
sField_CodeID = drW2PNEW("CodeID").ToString
End If
Try
MyRow = New DataGridViewRow
MyRow.CreateCells(dgvW2PNEW)
MyRow.SetValues("0",
imgNotOK.ToBitmap,
nField_ItemID,
nField_OrderID,
nField_Quantity
sField_Art,
sField_pscArticleID
sField_CodeID)
dgvW2PNEW.Rows.Add(MyRow)
Catch ex As Exception
ErrorLogging(True, "Sub FillW2PGrid: Add a line in the grid" & vbCrLf & ex.Message & vbCrLf & "SQL:" & sSQL & vbCrLf & ex.StackTrace.ToString, nErrorLevel_Error)
Finally
If Not MyRow Is Nothing Then
MyRow.Dispose()
MyRow = Nothing
End If
End Try
End While
End If
|
|
|
|
|
This is a third party product so you need to contact the person who wrote it.
|
|
|
|
|
sorry, but i am looking for a solution , if i could do that i will not post here my question
|
|
|
|
|
A solution to what? Your question is far from clear.
|
|
|
|
|
a solution for my problem , how to use this code with the new Datagridview, the probleme is with property hasrow, i add the data to the DataTable and use that as the binding source for the DataGridView.
|
|
|
|
|
There's multiple gridviews out there with the same name; not even sure which one to look at. For the normal GridView, we have documentation. Not so much for the unknown advanced version.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
|
The most appropriate place to ask questions about github projects is on the github project itself. The chances of the contributors happening on your question here are very small. The place to ask your question is here[^].
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
