Beginner looking for project ideas to practice C# – any suggestions?
Hello people! I want to ask for help. I need some pet project or projects for practice But I dont have any ideas left. So I wanna be a .net BackEnd dev. Here some info about what I already did so you may consider this when giving me some projects. Thank you.
Rust(game by Facepunch) plugins. Here is my works if you wanna take a look: https://umod.org/user/Notchu#plugins
Telegram Bots via TelegramBot library(polls bot, superchat bot that creates chat In group for each person, so admins can chat personally in superchat)
Also Decision Making Bot using OpenAi, and some other bots that are using Postgressql but just a bit
WTelegramClient + Google Sheets(I made a bot that collects data from channels and writes it down to sheets)
Personal API - Just a simple one that I use for open ai. Its just uhm for practice so in my project I use my api instead of OpenAiApi. Also this apo can send messages via telegram if needed
uMod - Profile - Notchu
uMod is a universal modding platform, framework, and plugin API for Unity, .NET/C#, Unreal, and C++ games
26 Replies
$projects
Collections of application ideas that anyone can solve in any programming language to improve coding skills:
https://github.com/dotnet/dotnet-console-games
https://github.com/karan/Projects
https://github.com/florinpop17/app-ideas
Are you specifically looking to get a job in the industry as a backend .net dev?
If so, I'd say nows a good time to start learning about adjacent technologies that are commonly used on, let's say, .net web apis. I.e., SQL & EF Core.
Yeah, backend .net dev
I do know some of EF Core I had some practice. I have a bot that transcribes voice message in Text message via whisper. I made database to make a limit of day usage for example 15 minutes
But about sql I dont have any experience with it.
Could you be so kind to tell me something more specific about what to do? I would be really grateful. Im not sure Can I ping you but Ill try xD
@November
Sure!
In the enterprise world, you'd be surprised at how much data is still driven by Excel and csv files if you've never been exposed to it before. A great starter project is building a .Net Web API CRUD app using EF Core and SQL. You'll learn some basic data modeling and SQL, which is always handy. And sticking with the spirit of data files, the purpose of your API can be around uploading and parsing CSV files into structured data and saving that to your SQL database, as well as exposing CRUD endpoints around those models.
But uhm how can I parse Csv data to database If I dont know the template of the file?
Or should I just write it down to db as object?
Without specific class. Sorry for maybe stupid questions but I really didnt get this
Great question! You would simply enforce a "type" of CSV file that your API can parse. In the real world - a client would provide these requirements and definitions for what each CSV file will look like. For the sake of a demo app, you can just create your own. For instance, something as simple as =>
The Matrix Reloaded, $150M, May 15 2003 and boom that's your format. Every CSV file will look like this and the API's responsibility is to extract this data from the file and turn it into a Movie database object.Okay Now I guess I got it. Thank you very much! Is it okay If i Wont close this thread so I can tag you later for new task?😅
yeah no prob!
Best of luck!
I ment luck 😂
Excellent suggestions already. I'll add discord bot to the list, as it can be combined with a web API for great effect
So I can send csv file to bot?
More like, you'd make a bot that does something, then stores/gathers data from a sql database, and can output reports in CSV/excel format for example
either via the api or the bot itself
also doing something like pastebin would be useful
A url shortener has limited scope and touches a lot of layers too.
Hey @November . I made this API but I feel like I store data only in strings but i can fix that. For now can you uhm, rate it when you will have time?
Here is the link: https://github.com/as-notchu/CSVProcessor
GitHub
GitHub - as-notchu/CSVProcessor
Contribute to as-notchu/CSVProcessor development by creating an account on GitHub.
I'll set a reminder to look at this some time today
Thank you! Appreciate that!
@Notchu Thoughts:
This is a pretty good start. I think it captures the requirements of the assignment.
Some things I noticed:
- In your ctor for FilmData, you can do
FilmData(Guid? id = null) and update the body to null coalesce to a new Guid. That way you can use this ctor in the Update controller method and don't need to manually map your dto.
- I don't like the mixing of sometimes returning a service result object and sometimes not for the DataService methods. I'd prefer if they were all unified to either always return a ServiceResult wrapper or not
Some other design considerations:
- consider what happens if someone uploads a csv document that includes a Film data that describes a record already in the database. How should the api handle this?
Sorry if the formatting is bad, I'm on mobile.Thank you ! I was thinking of returning ServiceResult always but I was too tired today because I was figuring out a lot of new stuff.
About design consideration.
I just completely forgot about csv controller xD. But, I dont really know how api can handle film that is already in the database. Should I just look for a same description each time I upload a csv?
What do you think, if Ill continue putting same effort, when Ill be able to call my self “Junior”?
There's a few ways to solve it. You can set up an index on "Title" and set a constraint to make it unique and fail on inserting duplicates.
Or you can query to find existing records and do an update or insert query, updating existing records and inserting new ones.
I would say this is more or less this is junior level code.
It is a basic CRUD app that solves a specific problem (handling csv). And you can incrementally introduce more complexity to test yourself:
E.g., handling duplicate data, handling different file types
I was thinking of just looking throught films by “pages” to find duplicates. I know its useless for this small app but I thought its a good practice, isnt it?
I can add more features, make it more complex. If Ill do that, will you take a look?
I was thinking of modifying FilmData by adding actors and duration of film, creating filters.
Actors would be a good idea and introduce a good bit of complexity
Not sure what is meant by "pages", but you can look up and reference EF Core "upsert" to get some ideas
I can try adding actors as separate class and build db relationships (many to many, etc)
Its called batch or smth like that. I may be wrong
Batching is just the concept of combining all your updates into a single query:
https://learn.microsoft.com/en-us/ef/core/performance/efficient-updating?tabs=ef7
Efficient Updating - EF Core
Performance guide for efficient updating using Entity Framework Core
Got it
Thank you
See you later here xD