Skip to content

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Category: AI

AI

AI Prompt: Negotiate Your Salary with AI-Prepared Talking Points

- 17.02.26 - ErcanOPAK comment on AI Prompt: Negotiate Your Salary with AI-Prepared Talking Points

Salary negotiation is nerve-wracking without preparation. AI coaches you with specific talking points. The Prompt: Help me prepare for salary negotiation: My role: [Job title] My experience: [X years] Current salary: [$X or N/A if new job] Target salary: [$X] Their offer: [$X if applicable] Location: [City/Remote] Company type: [Startup/Corp/etc] My strengths: [Key skills/achievements] Prepare: […]

Read More
AI

AI Prompt: Explain Your Medical Test Results in Plain Language

- 17.02.26 - ErcanOPAK comment on AI Prompt: Explain Your Medical Test Results in Plain Language

Blood test results full of confusing numbers and abbreviations? AI explains what they mean. The Prompt: Explain these medical test results in plain English: [Paste or type your results] For each value: 1. What does this measure? 2. Is my value normal, high, or low? 3. What does abnormal mean for health? 4. What lifestyle […]

Read More
AI

AI Prompt: Create Personalized Workout Plan Based on Equipment and Goals

- 17.02.26 - ErcanOPAK comment on AI Prompt: Create Personalized Workout Plan Based on Equipment and Goals

Generic workout plans don’t fit your equipment or schedule. AI creates perfectly tailored plan. The Prompt: Create personalized workout plan: My equipment: [gym / home / dumbbells only / no equipment] Goal: [lose weight / build muscle / improve endurance / stay active] Current level: [beginner / intermediate / advanced] Days per week: [3/4/5/6] Time […]

Read More
AI

AI Prompt: Review Code for Security Vulnerabilities

- 16.02.26 - ErcanOPAK comment on AI Prompt: Review Code for Security Vulnerabilities

Manual security reviews miss issues. AI scans code for common vulnerabilities comprehensively. The Prompt: Review this code for security vulnerabilities: [Paste code] Check for: 1. SQL Injection 2. XSS (Cross-Site Scripting) 3. CSRF vulnerabilities 4. Authentication issues 5. Authorization flaws 6. Input validation problems 7. Sensitive data exposure 8. Insecure dependencies 9. API security issues […]

Read More
AI

AI Prompt: Generate Database Schema from Description

- 16.02.26 - ErcanOPAK comment on AI Prompt: Generate Database Schema from Description

Designing database schema takes hours. AI creates normalized schema with relationships instantly. The Prompt: Design database schema for: [Describe your application] Requirements: 1. Normalized (3NF minimum) 2. Include primary keys, foreign keys 3. Add indexes for common queries 4. Specify data types (be specific) 5. Add constraints (NOT NULL, UNIQUE, etc.) 6. Show relationships (1:1, […]

Read More
AI

AI Prompt: Convert Requirements Document to User Stories

- 16.02.26 - ErcanOPAK comment on AI Prompt: Convert Requirements Document to User Stories

Writing user stories from requirements is tedious. AI converts them automatically in proper format. The Prompt: Convert these requirements to user stories: [Paste requirements document] Format each as: – As a [role] – I want [feature] – So that [benefit] Also include: – Acceptance criteria (Given/When/Then) – Story points estimate (1-13 scale) – Priority (High/Medium/Low) […]

Read More
AI

AI Prompt: Create API Documentation from Code

- 15.02.26 - ErcanOPAK comment on AI Prompt: Create API Documentation from Code

Writing API docs is boring. AI generates beautiful documentation from your endpoints. The Prompt: Create API documentation for these endpoints: [Paste controller/routes code] Format as: 1. Endpoint overview table 2. For each endpoint: – HTTP method and path – Description – Request parameters (query, path, body) – Request example (curl + code) – Response format […]

Read More
AI

AI Prompt: Refactor Legacy Code to Modern Patterns

- 15.02.26 - ErcanOPAK comment on AI Prompt: Refactor Legacy Code to Modern Patterns

Cleaning up old code manually takes days. AI refactors to modern patterns while preserving logic. The Prompt: Refactor this legacy code to modern best practices: [Paste old code] Target language version: [e.g., C# 11, ES2023] Apply: 1. Modern syntax (async/await, arrow functions, etc.) 2. Design patterns where appropriate 3. Better naming conventions 4. Remove code […]

Read More
AI

AI Prompt: Generate Unit Tests from Existing Code

- 15.02.26 - ErcanOPAK comment on AI Prompt: Generate Unit Tests from Existing Code

Writing tests is tedious but necessary. AI generates comprehensive test cases automatically. The Prompt: Generate unit tests for this code: [Paste your function/class] Requirements: 1. Use [testing framework – e.g., Jest, xUnit, pytest] 2. Test happy path 3. Test edge cases (null, empty, invalid input) 4. Test error handling 5. Include setup/teardown if needed 6. […]

Read More
AI

AI Prompt: Create Comprehensive README for GitHub Project

- 15.02.26 - ErcanOPAK comment on AI Prompt: Create Comprehensive README for GitHub Project

README writing is tedious. AI creates professional documentation from your code. The Prompt: Create README.md for this project: Project description: [Brief description] Main files: [List key files] Tech stack: [Languages/frameworks] Purpose: [What it does] Include: – Project title with badges – Description – Features list – Installation steps – Usage examples – Configuration options – […]

Read More
AI

AI Prompt: Summarize YouTube Video from Transcript

- 15.02.26 - ErcanOPAK comment on AI Prompt: Summarize YouTube Video from Transcript

Long video but need quick summary? AI extracts key points from transcript. Get Transcript: Use YouTube transcript feature or browser extension The Prompt: Summarize this video transcript: [Paste transcript] Provide: 1. 3-sentence summary 2. Key points (bullet list) 3. Main takeaways 4. Timestamps for important sections (if mentioned) 5. Action items (if tutorial/how-to) Format for […]

Read More
AI

AI Prompt: Brainstorm Creative Solutions to Business Problems

- 15.02.26 - ErcanOPAK comment on AI Prompt: Brainstorm Creative Solutions to Business Problems

Stuck on business challenge? AI generates creative approaches you might not consider. The Prompt: I’m facing this business challenge: [Describe problem in detail] Our constraints: – Budget: [amount] – Timeline: [timeframe] – Team size: [number] – Must avoid: [limitations] Generate 10 creative solutions: 1. Include unconventional approaches 2. Mix of low-cost and premium options 3. […]

Read More
AI

AI Prompt: Create Excel Formulas from Description of What You Want to Calculate

- 14.02.26 - ErcanOPAK comment on AI Prompt: Create Excel Formulas from Description of What You Want to Calculate

Excel formulas syntax confusing? Describe what you want in plain English, get working formula. The Prompt: Create Excel formula for: I have: – Column A: Product names – Column B: Prices – Column C: Quantities sold I want in Column D: Total revenue (price × quantity), but only for products starting with “Pro-” If quantity […]

Read More
AI

AI Prompt: Generate SQL Queries from Plain English Descriptions

- 14.02.26 - ErcanOPAK comment on AI Prompt: Generate SQL Queries from Plain English Descriptions

Know what data you need but struggling with SQL syntax? AI writes the query for you. The Prompt: Write SQL query for this: Database: Ecommerce Tables: Users (id, name, email), Orders (id, user_id, total, created_at) I need: Top 10 customers by total order value in last 30 days Also explain what each part does. AI […]

Read More
AI

AI Prompt: Debug Code by Explaining Error Message in Plain English

- 14.02.26 - ErcanOPAK comment on AI Prompt: Debug Code by Explaining Error Message in Plain English

Cryptic error messages confusing you? AI explains what they mean and how to fix them. The Prompt: I got this error in [language/framework]: [Paste full error message and stack trace] Please explain: 1. What this error means in plain English 2. What likely caused it 3. How to fix it with code example 4. How […]

Read More
AI

AI Prompt: Generate Regex Patterns with Explanation and Test Cases

- 13.02.26 - ErcanOPAK comment on AI Prompt: Generate Regex Patterns with Explanation and Test Cases

Struggling with regex syntax? AI writes the pattern and explains how it works. The Prompt: Create a regex pattern that matches: – US phone numbers in formats: (555) 123-4567, 555-123-4567, 5551234567 Provide: 1. The regex pattern 2. Explanation of each part 3. 5 test cases (3 valid, 2 invalid) 4. Code example in JavaScript AI […]

Read More
AI

AI Prompt: Convert Handwritten Notes Photo to Formatted Markdown

- 13.02.26 - ErcanOPAK comment on AI Prompt: Convert Handwritten Notes Photo to Formatted Markdown

Took handwritten meeting notes on paper? AI transcribes and formats them into clean digital text. The Prompt: Transcribe this handwritten note image into clean Markdown format: [Upload photo of handwritten notes] Requirements: – Fix any unclear words (best guess) – Organize into bullet points or numbered lists – Use headers for main topics – Bold […]

Read More
AI

AI Prompt: Analyze Email Thread and Summarize Action Items by Person

- 13.02.26 - ErcanOPAK comment on AI Prompt: Analyze Email Thread and Summarize Action Items by Person

Long email chains with scattered tasks? AI extracts who needs to do what. The Prompt: Analyze this email thread and create action items organized by person: [Paste entire email thread] Format: **John:** – [ ] Task 1 (due: date if mentioned) – [ ] Task 2 **Sarah:** – [ ] Task 3 **No owner assigned:** […]

Read More
AI

AI Prompt: Generate Realistic Test Data for Development

- 13.02.26 - ErcanOPAK comment on AI Prompt: Generate Realistic Test Data for Development

Need 100 fake users for testing? AI generates realistic test data instantly. The Prompt: Generate 50 realistic user records as JSON with: – First name, last name – Email (use fake domains) – Phone number (US format) – Address (real US cities, fake street addresses) – Birthday (ages 18-80) – Account balance (random $0-$10,000) Make […]

Read More
AI

AI Prompt: Simplify Legal Documents into Plain English

- 13.02.26 - ErcanOPAK comment on AI Prompt: Simplify Legal Documents into Plain English

Can’t understand your rental agreement or terms of service? AI translates legalese into normal language. The Prompt: Explain this legal text in simple terms a 10-year-old would understand: [Paste legal paragraph] Highlight any: – Important obligations I’m agreeing to – Risks or penalties – Red flags I should know about Example: Legal: “Party A hereby […]

Read More
AI

AI Prompt: Turn Meeting Notes into Actionable Task Lists

- 13.02.26 - ErcanOPAK comment on AI Prompt: Turn Meeting Notes into Actionable Task Lists

Meeting notes scattered everywhere? AI organizes them into clear action items. The Prompt: Extract action items from these meeting notes: [Paste your meeting notes] For each action item provide: 1. Task description 2. Owner (who’s responsible) 3. Due date (if mentioned) 4. Priority (High/Medium/Low) Format as checklist I can copy to project management tool. Example […]

Read More
AI

AI Coding Assistant: ChatGPT Prompts That Generate Production-Ready Code

- 05.02.26 - ErcanOPAK comment on AI Coding Assistant: ChatGPT Prompts That Generate Production-Ready Code

Tired of AI giving you buggy code snippets? These structured prompts extract perfect, tested code from ChatGPT and Copilot. The Structure for Perfect Code Generation: ROLE: Senior [Language] Developer with 10 years experience TASK: Create [specific feature] CONSTRAINTS: [technical limitations] REQUIREMENTS: [must-have features] OUTPUT FORMAT: [code structure] TEST: [validation criteria] Example: ROLE: Senior C#/.NET Developer […]

Read More
AI

AI Prompt Engineering: How to Get Perfect Images Every Time with Midjourney

- 05.02.26 - ErcanOPAK comment on AI Prompt Engineering: How to Get Perfect Images Every Time with Midjourney

Struggling with AI image generators giving you weird results? These precise prompt templates transform random outputs into masterpiece-quality images. The Anatomy of a Perfect AI Image Prompt: [Subject] + [Detailed Description] + [Art Style] + [Artist Reference] + [Technical Parameters] BAD: “A dog in a park” GOOD: “Golden retriever puppy playing with red ball in […]

Read More
AI

AI Prompt: Analyze Contracts and Legal Documents to Find Hidden Fees and Unfair Terms

- 03.02.26 - ErcanOPAK comment on AI Prompt: Analyze Contracts and Legal Documents to Find Hidden Fees and Unfair Terms

Signing a lease, employment contract, or service agreement? AI can highlight hidden fees, unfair clauses, and red flags you might miss. The Contract Analysis Prompt: I need help analyzing a legal contract before signing. **Document Type:** [e.g., Apartment Lease, Employment Contract, Service Agreement, Phone Plan] **Full Contract Text:** [Paste entire contract here] **What I Need:** […]

Read More
AI

AI Prompt: Transform Any Recipe to Match Your Dietary Restrictions and Available Ingredients

- 03.02.26 - ErcanOPAK comment on AI Prompt: Transform Any Recipe to Match Your Dietary Restrictions and Available Ingredients

Found the perfect recipe but you’re vegan, gluten-free, or missing half the ingredients? AI can adapt any recipe to your needs while keeping it delicious. The Recipe Adaptation Prompt: I need help adapting a recipe to my dietary needs and available ingredients. **Original Recipe:** [Paste entire recipe here – ingredients and instructions] **Dietary Restrictions:** [e.g., […]

Read More
AI

AI Prompt: Diagnose Home Repair Issues with Photos and Get Step-by-Step Fix Instructions

- 03.02.26 - ErcanOPAK comment on AI Prompt: Diagnose Home Repair Issues with Photos and Get Step-by-Step Fix Instructions

Strange noise from your HVAC? Leak under the sink? Use AI to diagnose and get repair instructions without calling an expensive technician. The Diagnostic Prompt Template: I need help diagnosing and fixing a home repair issue. **The Problem:** [Describe what’s wrong: noise, leak, not working, etc.] **Location:** [Where: kitchen sink, basement furnace, bedroom ceiling, etc.] […]

Read More
AI

AI Prompt: Plan the Perfect Road Trip with Hidden Gems and Time Optimization

- 01.02.26 | 01.02.26 - ErcanOPAK comment on AI Prompt: Plan the Perfect Road Trip with Hidden Gems and Time Optimization

Skip generic tourist traps and discover authentic local experiences with this comprehensive road trip planning prompt. The Ultimate Road Trip Planner Prompt: You are a travel planning expert with deep knowledge of hidden gems and local culture. Create a detailed road trip itinerary. **Trip Details:** – Start: [City/Location] – End: [City/Location] – Duration: [Number of […]

Read More
AI

AI Prompt: Debug Production Errors by Analyzing Stack Traces and Logs

- 01.02.26 | 01.02.26 - ErcanOPAK comment on AI Prompt: Debug Production Errors by Analyzing Stack Traces and Logs

Stop spending hours deciphering cryptic error messages. This prompt turns stack traces into actionable debugging steps. The Master Debugging Prompt: You are a senior software engineer debugging a production issue. Analyze the following error and provide a step-by-step debugging plan. **Error Context:** Application: [e.g., ASP.NET Core Web API] Environment: [Production/Staging] Frequency: [How often does this […]

Read More
AI

AI Prompt: Generate Production-Ready API Documentation from Code Comments

- 01.02.26 | 01.02.26 - ErcanOPAK comment on AI Prompt: Generate Production-Ready API Documentation from Code Comments

Turn scattered code comments into beautiful, structured API docs in seconds with this prompt template. The Prompt Template: You are a technical documentation expert. Analyze the following code and generate comprehensive API documentation. **Input Code:** [PASTE YOUR CODE HERE] **Output Requirements:** 1. Extract all public methods/endpoints 2. For each endpoint, document: – HTTP method and […]

Read More
AI

Plan a Real-Life Skill Upgrade in 30 Days

- 31.01.26 - ErcanOPAK comment on Plan a Real-Life Skill Upgrade in 30 Days

Not productivity porn. Real execution. Prompt Create a 30-day plan to learn [SKILL].Constraints: max 45 minutes per day no paid resources weekly measurable outcome final real-world deliverableAvoid motivational language. Be practical. Why it works AI shines at structured planning, not motivation.

Read More
Page 1 of 5
1 2 3 4 5 Next »

Posts navigation

Older posts
February 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
232425262728  
« Jan    

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (935)
  • How to add default value for Entity Framework migrations for DateTime and Bool (832)
  • Get the First and Last Word from a String or Sentence in SQL (826)
  • How to select distinct rows in a datatable in C# (799)
  • How to make theater mode the default for Youtube (716)
  • Add Constraint to SQL Table to ensure email contains @ (574)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (553)
  • Average of all values in a column that are not zero in SQL (520)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (474)
  • Find numbers with more than two decimal places in SQL (436)

Recent Posts

  • C#: Use MemoryPack for 10x Faster Serialization than JSON
  • C#: Use params ReadOnlySpan for Allocation-Free Variable Arguments
  • C#: Use ObjectPool for Reusing Expensive Objects
  • C#: Use Lazy for Expensive Object Initialization
  • SQL: Use STRING_AGG to Concatenate Rows into Comma-Separated List
  • SQL: Use Filtered Indexes to Index Only Subset of Rows
  • .NET Core: Use Result Pattern to Avoid Exceptions for Expected Errors
  • .NET Core: Use IOptions Pattern for Strongly-Typed Configuration
  • Git: Use .gitattributes to Handle Line Endings Across OS
  • Git: Use git notes to Add Comments to Commits Without Changing History

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (935)
  • How to add default value for Entity Framework migrations for DateTime and Bool (832)
  • Get the First and Last Word from a String or Sentence in SQL (826)
  • How to select distinct rows in a datatable in C# (799)
  • How to make theater mode the default for Youtube (716)

Recent Posts

  • C#: Use MemoryPack for 10x Faster Serialization than JSON
  • C#: Use params ReadOnlySpan for Allocation-Free Variable Arguments
  • C#: Use ObjectPool for Reusing Expensive Objects
  • C#: Use Lazy for Expensive Object Initialization
  • SQL: Use STRING_AGG to Concatenate Rows into Comma-Separated List

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com