|
1. Learn the basics of how databases work. Both design and actually using one.
2. Choose a database to use
3. Learn how C# interfaces with databases in general and specifically how the database in 2 works with C#.
4. Design a table that will hold the data. This follows from 1.
5. Put all of the above together.
|
|
|
|
|
I know this may seem arbitrary to some, but the nature of the project that I am currently working on makes this capability an easy way to solve several problems.
I want an efficient, seamless way to integrate values into a stream of characters. I have done this in the past by just converting byte values into chars or even using value.tostring() but it would be more efficient if the characters could be read directly from the memory containing the values. (Examples: an integer is read as 2 characters, a long is read as 4 characters and a GUID is read as 8 characters). This would be really simple in C++. In c# it is turning out to be a huge challenge.
I tried using a generic with using StructLayout.Explicit but I got a runtime error stating that this is not supported. Using non-generics doesn't work either because strings and arrays are classes while values are structs and mixing them also doesn't work for the simple reason that the non zero terminated strings used in .NET track data that is probably inconsistent with this layout.
Is there any way to directly read (or even copy) data from numeric value bytes into a string? I can think of one possibility using unsafe copying but was wondering if I had any other better (more efficient) options.
|
|
|
|
|
I was unable to create a structure that did this. However, I was able to create a generic extender that uses "unsafe" copying to perform the task. The code is below. Still not sure this is the most efficient way to accomplish the task, but it works. The code requires using System.Runtime.InteropServices
public unsafe static string ToBytewiseString<T>(this T item) where T : struct
{
Type t = typeof(T);
int size = t.GetSize();
GCHandle pinnedHandle = GCHandle.Alloc(item, GCHandleType.Pinned);
IntPtr ptr = pinnedHandle.AddrOfPinnedObject();
StringBuilder result = new StringBuilder();
int increment;
if ((size % 2) == 1)
increment = 1;
else
increment = 2;
for (int offset = 0; offset < size; offset += increment)
{
char* c = (char*)((byte*)ptr + offset);
if (increment == 1)
{
ushort c_ = *c;
result.Append((char)(c_ >> 4));
--offset;
increment = 2;
}
else
result.Append(*c);
}
pinnedHandle.Free();
return result.ToString();
}
modified 29-Dec-21 2:32am.
|
|
|
|
|
I am tempted to suggest that you switch to C/C++.
If I understand your question right, you are asking for a C# equivalent of C/C++ 'union'. In my opinion, not offering unions is one of the strong arguments for C# over C/C++.
For the oldtimers: union is a C variant of FORTRAN COMMON blocks, which is one of the craziest ideas of language design! Also, it was one of the greatest threats ever to software robustness.
Doing a simple search for 'C# union' I hit upon C# equivalent to C "union"[^]. I never was aware of StructLayout(LayoutKind.Explicit) and FieldOffset(). Honestly: I haven't been missing out on anything valuable. I may try to forget that I have ever seen it. But maybe you can make use of it.
|
|
|
|
|
trønderen wrote: union is a C variant of FORTRAN COMMON blocks
No, COMMON blocks were there so you could share memory between modules. A C union does not provide any sharing capability.
|
|
|
|
|
The common property between unions and common blocks is that they both provide to different users a common blob, telling: Here is a binary blob - interpret it any way you want!
Details in accessability are different; in C you may have somewhat better control over which modules have access to the union definition. And you have collected all the different interpretations of that binary blob in one place (at least until you start casting pointer types).
Yet, the basic concept is the same: A binary blob that can be interpreted in any way that the accessor would like to. Sure, it must be one of the alternatives in the union definition. Just like an interpretation of a Fortran COMMON block must be according to one of the alternative source code definitions that COMMON block in the modules that may access it.
You may argue that collecting the COMMON block definitions / union alternatives in a single place is an improvement. Yes, it is, but the basic idea of a binary blob providing multiple interpretations is the same.
You may argue that while any Fortran module might access that binary COMMON blob, only those C modules including the definition of the union, and knowing the address of (if you like: a pointer to) a union instance, this doesn't give any sort of protection against the uncontrolled interpretation of the binary blob.
Even Fortran COMMON block had some accessability control: You had not only the plain, anonymous COMMON blocks but also named COMMON blocks - sort of comparable to letting only selected modules #include the union type definition: If you didn't know the name of the blob, you didn't have access to it. Sure, it was a poor kind of protection, but lots of protection is based on the (lack of) knowledge of how to access it. C/C++ provides a somewhat better protection.
In this case, considering how easily any C pointer can be cast into a pointer of any other type - and note: the definition of the target type is arbitrary; it doesn't have to be any centrally managed type definition - the type control of C/C++ lies much closer to the weak Fortran type check than to that of C#.
|
|
|
|
|
Whilst you could use COMMON (in FORTRAN) to 'union' data in separate routines, you could not redefined the same COMMON block in the same routine. However, you could use another statement called EQUIVALENT (IIRC - it is some decades since I last wrote any FORTRAN) which does do 'union's - it was often used to remap data in COMMON blocks, but it was not restricted solely to data in COMMON blocks although that was its most frequent use in programs that I inherited in the 1980s.
|
|
|
|
|
Geesh. Did you read my OP? Considering the rest of your post, I guess I shouldn't be that surprised. I already tried an Explicit layout. From my OP: "I tried using a generic with using StructLayout.Explicit but I got a runtime error stating that this is not supported". In other words currently, .NET doesn't allow using explicit layouts with generics. And just because YOU don't find anything valuable doesn't mean it isn't. You apparently don't understand the nature of efficient memory management; nor "robustness"; and your disregard for "oldtimers" is very revealing about both your experience and nature. I would change that attitude before you spend your life eating your words. FYI, my reply above to my own topic is a solution to the problem. What is more robust than not having to introduce a new data type?
modified 30-Dec-21 2:48am.
|
|
|
|
|
primem0ver wrote: ou apparently don't understand the nature of efficient memory management; nor "robustness"; and your disregard for "oldtimers" is very revealing about both your experience and nature.
Hmmmm...
I have 15 years in C/C++. And probably 10 in assembly. I worked on systems with 4k memory.
I have written heap management replacement systems for C and C++ specifically implemented to improve performance for specific applications.
And I have spent decades doing bit twiddling. And I have used the union mechanism in C/C++.
I also have more than a decade in Java. And more than a decade in C#. Each.
In contrast to that I specialize in large systems built to handle millions of customers with sustained throughput of thousands of TPS. I have friends who work with hundreds of thousands of sustained TPS.
I have profiled applications extensively in C++, C# and Java. Not to mention decades of designing applications.
Just wanted to establish what my actual experience is before commenting on what you said.
Presumably this is based on an actual documented design or actual profiling of an existing application under realistic loads and on realistic hardware.
Given that is the case then I would suggest is that if you have a project which actually requires a micro optimization at that level that you should seriously think of using a different language than C#. Such as C/C++. You can create a library with the required functionality and link it in to your C# application. Or even create a stand alone application which handles requests from the C# app. If I had that actual need I would go with the stand alone server. It is going to make maintenance and implementation a lot easier.
|
|
|
|
|
trønderen wrote: I am tempted to suggest that you switch to C/C++.
That is what I was thinking also.
trønderen wrote: I may try to forget that I have ever seen it. But maybe you can make use of it.
lol. Probably a good idea. Tricks like that in C/C++ were to, presumably, to squeeze extra performance out of some small system. Large systems are not impacted by micro optimizations and so one should focus on real performance solutions rather than attempting stuff like this.
|
|
|
|
|
I use MemoryStreams and BinaryReaders / BinaryWriters for handling "binary" data; "characters" being something that depends on the encoding.
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
|
|
|
|
|
I believe the question is about directly mapping from memory into a value. And not how to store it in a stream.
|
|
|
|
|
Efficient is a subjective word. It often is used in the place of fast or sometimes associated with less memory or throughput. Performance is a also often used as well.
None of those mean anything without a context. A medical monitor, a CRC controller and a facebook page are vastly different things and performance means something different for all of them.
In general and almost always the following is what impacts this
1. Business requirements (highest)
2. Architecture
3. Design
4. Implementation (lowest). This also includes adhoc designs that were done without thinking.
It has been proven that developers do not predict impactors on performance when based solely on the implementation level and without profiling. The other levels require human skill.
Optimizations at the first level are capable of having orders of magnitude impacts on the performance of systems. The impact goes done significantly at each level. At the bottom level implementation improvements are unlikely to improve the system by more than 10% unless the a factor comes into play that is actually better addressed by a failure in the levels above it.
primem0ver wrote: I can think of one possibility using unsafe copying but was wondering if I had any other better (more efficient) options.
The memory mapped variables that you are referring to are "unsafe" because, as proven by decades in C++/C that programmers use them wrong, especially over time. And those failures lead to application crashes. Not just small annoyances but rather problems that make the OS terminate the application immediately. Often in ways that seemingly have nothing to do with where the actual bad code is.
So presumably the need for efficiency is real one. One that has been measured. One that is not actually a failure from one of the other levels.
So if a real need exists and one that has been localized, measured, and designed such that such an optimization can improve something in the enterprise, then as suggested elsewhere use C/C++. Then map away. And if was me I would create a separate executable with just that code. Then when the exe crashes it will not take the rest of the enterprise down.
|
|
|
|
|
How to read/write register command in dot net
|
|
|
|
|
You need to provide considerably more detail about your problem.
|
|
|
|
|
You need to know the address of the device (slave id). Then you have to connect to the device; using whatever protocol it expects. Then you can send read / write register requests.
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
|
|
|
|
|
Hi,
Which text Editor can be configured to highlight keywords of special programming language(in my case - PPL )? I am looking for Editor with clear and understandable instructions.
|
|
|
|
|
|
Thank you for link on article with detailed explanations. Unfortunally it is good for old versions NetBeans & jdk, so I continue to search.
|
|
|
|
|
I was expecting at least 10 people to shout: Notepad++ !!!
For some reason, that didn't happen.
I presume that we are talking Windows. There is supposed to be a Linux version of it, but I never tried it under Linux, and don't know whether it is fully functional, stable or in other ways suitable.
Maybe even the Windows version doesn't satisfy your requirements. Maybe it doesn't satisfy your understanding of 'clear and understandable instructions'. Several years ago, I did add syntax coloring for another (script) language, and found it fairly simple - but I am not afraid of editing XML files by hand.
In any case, NPP is a great pure text editor. I have used it since I left DOS and Brief ... Some people say that NPP was more a clone of Brief than of Windows Notepad, and I tend to agree. Today it has developed far beyond either.
You can find NPP at notepad-plus-plus.org[^]
|
|
|
|
|
Thank you. I added highlighting keywords in Notepad++ for my language PPL (Parentheses Programming Language). It is working, not at all clear, but working. Good decision, I was looking enough time without result and was ready to write own utility for highligting, but instead of that I have time for other things. Thank you very much again and Happy New Year!
|
|
|
|
|
I'd like to port my WPF/.NET6 app to MAUI so I can target MacOS. I know MAUI is still a work in progress until next spring, but are there any good materials specifically on porting WPF to MAUI available yet?
FYI, in the research I've done so far, these are the biggest differences/issues I've found.
1. Control properties are not directly accessible and must be set with handlers with an IF branch for each targeted platform.
2. I'll have to learn the Xamarin flavor of XAML (I assume it's similar to WPF XAML).
3. I'll have to learn how to deploy MAUI apps. I've been using ClickOnce up to this point.
4. I'll need to buy a Mac and use Visual Studio for Mac to compile for the Mac OS target.
|
|
|
|
|
Is it "MAUI" or Xamarin you need to learn? You don't need a Mac to learn Xamarin and bet 6 months on vaporware.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
Thanks, Gerry. The available in-depth information on MAUI is spotty, but from what I understand one possible path is to start refactoring the WPF app into Xamarin now, and then there will be update tools (part of VS?) that should make porting from Xamarin to MAUI more straightforward.
My hope was that someone has already created a tutorial or video that took a specific look at what it would be like to go from WPF directly to MAUI. I'm sure there are some devil-in-the-details issues that's just not being discussed in the plethora of "Hello World" .NET6/MAUI presentations right now. I found one YouTube video here, but the audio is hard to follow. It's the right idea, but I was hoping for more of these.
As for needing a Mac, I think it can compile the project, but there's no emulator for testing in VS right now. This is all new to me. I have a decade of learning to catch up on.
|
|
|
|
|
Hi all. I am a newbie to writing API's. Should I start with ASP.NET Core or ASP.NET Framework? Can I use them for backend development too?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
