Code

Discussion on C# DAL Generator for MySQL

Discussion on C# DAL Generator for MySQL

Cart 47 sales

NajmulIqbal15 supports this item

Supported

This author's response time can be up to 5 business days.

6 comments found.

after DAL is generated what configuration is required if we want to use remote mysql server?

Hi, Thanks for your interest in our app.

To use a remote or local MySQL, you will need to change the connection string accordingly. A sample application has been provided with a configuration file (web.config) that you can check to know how to provide database server details.

Thanks.

Hi same problem of C# for SQL Server. Source code not exist.

Item Purchase Code: 9d025900-8de8-4a76-9f1f-c1285053cb54

Purchase Date: 2016-07-05 11:19:49 UTC

Before you have only one type of license. On my purchase I have the full source code. After this change i don’t have the source, for previous customers it’s good don’t change. I don’t like. Thanks

Before you have only one type of license. On my purchase I have the full source code. After this change i don’t have the source, for previous customers it’s good don’t change. I don’t like. Thanks

Hi,
Previously it has only Tools license but we want to enable users to purchase Regular as well as Extended license. So that was the main reason that we provided source code separately (in the .Net category). Can you please send me an email via my profile page to discuss it further and to help if you have lost previous versions files?

Hi, before i buy the source code license. Today i download the update but all source code files isnt present on your zip files.

Item Purchase Code: ceb915f2-1bc9-43ae-9233-76d5071ac4ea

Purchase Date: 2016-07-05 10:17:05 UTC

Hi,
Source code is available separately. Below is the list of all the code generators with source code.
https://codecanyon.net/collections/6380844-code-generators-with-source

Hi

The classes generated do not have the declared variables.  While replacing EF, I am having a difficult time with the CRUD. The objects were generated easy, but not easy copying the data from the Controller ACTIONS to the Generated DAL objects. 

If you look at the objects generated from this component, they’re are directed properties and not traditional methods, properties or 1St class C# object. So, when I want to use the ‘generated code from the DAL as objects in the controller or ViewModel its not easy to SET or GET for CRUD

Could you please if there is a better way on mapping the objects, since I am having to manually map every field.


using System;
using AutoMapper;
using DALmodels;

       //in my app – my ViewModel

public class Animal

{
  public string Name { get; set; }
  public int Speed { get; set; }
}

public class Program
{
   public static void Main()
   { Mapper.CreateMap<Animal,Animal>(); } //does not work, the classes generated dont have the declared variables
}

 

 

Can you include a short snippet sample on how to use the DAL object in the controller to GET and SET values, you do not have to write AutoMapper, just an example.

 

thanks

Hi,
I think you are creating a separate class library for the data access layer.
You will have to add all your generated classes to the Models directory of the MVC application. Also specify proper namespance like [ProjectName].Models when generating the classes. If it is still not clear then send me an email, I will create a sample and send it to you.

ok thanks will send you an email shortly.

Hi,
I got your email, created the example and sent you.

Hi can you tell me how to do a bulk update or add range, its taking a fairly longer calling, can you please provide a way or an update to help with bulk add/updates

Hi,
At the moment it does not support bulk add/update.
We will consider this for future versions.

Looks interesting might work for me I have some pre-sale queries please….

I want to undestand if this will replace EF, or substitue it

  1. can i create the DAL / EF objects for any MqSQL as a parameter functions or stored procedures or just a layer. Please explain its not clear to me.

  2. Can I create audit tables, how many times the function was called.

  3. Does it give me bulk operations like delete all/insert bulk also.

  4. Does it have timestamp option

     

  5. one more seprate query do you have user management option or plug in coming  also in ASP MVC identity 2.0 , I will buy if you do

Regards

Briant

Hi.
  1. This app creates one class per table. The class will contain all columns of the table as properties. It will create the following methods inside the class:
    • Add: It adds a new record.
    • Update: It updates an existing record.
    • Delete: It deletes an existing record.
    • Get: It gets an existing record.
    • GetAll: It gets all records. However, you can also specify whether this method should handle pagination, sorting and search.
  2. Currently it does not support auditing. You will have to handle it manually.
  3. At the moment it supports single delete and insert only.
  4. Timestamp column has been handled. Just create a column and set its data type as timestamp. This column will not be inserted/updated manually.
  5. At the moment I don’t have a User Management system. However, I have an ASP.Net MVC application and other code generators. Here is the portfolio of all my applications. https://codecanyon.net/user/najmuliqbal15/portfolio
by
by
by
by
by
by

Tell us what you think!

We'd like to ask you a few questions to help improve CodeCanyon.

Sure, take me to the survey