Akal Tech RSS Feed

Topic: Ability to specify alias/property name for constraints

Tue, 10 Nov 2009 20:27:51 GMT

Topic Description:

I have been playing with the V5 beta. One thing that I would like to see is the ability to override the property names of the constraint names. The naming convention is fine but it would be great if I can override these as desired on individual basis. Just like the Display Name, just add another option for Alias.

Ryan

Replies: 1
Last Reply: Tue, 10 Nov 2009 20:27:51 GMT
Reply By: Victor Gavriluk

Topic: Limit what items are loaded by designer

Sat, 28 Mar 2009 19:37:18 GMT

Topic Description: Hello,

I am dealing with a very large database about 2000+ tables/views etc and designer takes a while to load the schema. Is there a way to limit what is loaded in order to make the loading faster? It would be great if there was an option to selectively load tables or views or stored procs rather than the entire database schema.

Cheers,
Ryan

Replies: 1
Last Reply: Sat, 28 Mar 2009 19:37:18 GMT
Reply By: Ish Singh

Topic: Be able to define "base" timezone for autoconversions

Sat, 28 Mar 2009 19:39:15 GMT

Topic Description:

Would like to be able to set in the configuration file, an index for the timezone to be used as the "base" time zone when you set the library to Translate time zones using

<appSettings>
<add key="TranslateTimeZones" value="True" />
</appSettings>

What I mean by it being the base, is that currently when you do the above it translates everything to UTC time to store in the database, but we would liek to be able to specify a certain time zone so that other non object realted processes (auto jobs, Reporting engine, etc) dont have to do all the conversions, and just use the value as stored.

Thanks!

Replies: 1
Last Reply: Sat, 28 Mar 2009 19:39:15 GMT
Reply By: Ish Singh

Topic: ROWLOCK

Sat, 07 Mar 2009 00:40:29 GMT

Topic Description: Hey,

NOLOCK is handy, but so is ROWLOCK in many cases. Would it be possible to add a property UseRowLock?

Thanks,
Sigurd

Replies: 1
Last Reply: Sat, 07 Mar 2009 00:40:29 GMT
Reply By: Ish Singh

Topic: Tracking commands in transaction

Mon, 23 Feb 2009 12:38:44 GMT

Topic Description: Hello,

I have yet another request. When UseTransaction property is set on an object is there a way to tell how many commands have been executed? If not already there, something that provides this information will be very useful.

Cheers,
Ryan

Replies: 1
Last Reply: Mon, 23 Feb 2009 12:38:44 GMT
Reply By: Ish Singh

Topic: Another over load for BaseField.IN

Mon, 23 Feb 2009 12:37:07 GMT

Topic Description: Was wondering what is thought of being able to pass in a business object into a new overload of the basefield.In method.

It would be nice to create the second business object and just set the search fields and thier values on that object and then pass it to the IN method. That would then do find (if no resultset) and use the first column in resultset (if more than one was set to return) to get the values to set for the "in" clause for the first objects field.

will give example of what I am picturing
Note this is not a great example as this could be done with a simple join, but still shows the basics of the steps code would do.

set up the object you want to get list of values from for use in the IN clause
pass that object into the field of the object you want to do an IN search on

        If Me.TextBox_State.Text.Trim <> String.Empty Then 

            Using Orders As New Orders()  

                Using Customers As New Customers  

                    Customers.SetVisibleFields(True, Customers.CustomerID)  

                    Customers.State.Value = Me.TextBox_State.Text  

                    Customers.State.UseInSearch = True 

                    Orders.CustomerID.In(Customers)  

                    Orders.Find()  

                End Using  

            End Using  

        End If

Replies: 1
Last Reply: Mon, 23 Feb 2009 12:37:07 GMT
Reply By: Ish Singh

Topic: How about generating an Enum of field names?

Sun, 08 Feb 2009 13:07:12 GMT

Topic Description: Hello,

I have yet another small request/suggestion. It would be great if QO designer could also generate an enum of field names (same as property names).

Cheers,
Ryan

Replies: 1
Last Reply: Sun, 08 Feb 2009 13:07:12 GMT
Reply By: Victor Gavriluk

Topic: Ability to open containing folder from QO Designer

Thu, 29 Jan 2009 14:15:48 GMT

Topic Description: Hello,

How about QO Designer providing a quick way to open the folder that contains the .qos file. Also it will be useful to be able to open the folder for a template or open the template in an editor directly from the Designer.

Cheers,
Ryan

Replies: 1
Last Reply: Thu, 29 Jan 2009 14:15:48 GMT
Reply By: Ish Singh

Topic: Asynchronous Patterns

Tue, 13 Jan 2009 15:23:30 GMT

Topic Description: Any plans to add async method signatures to Quick Objects? Would be really cool if QO could plug-in directly to async scenarios without extra programming, similar to SqlDataReader with BeginExecuteReader and EndExecuteReader.

Thanks,

Thomas

Replies: 2
Last Reply: Tue, 13 Jan 2009 15:23:30 GMT
Reply By: Sigurd Decroos

Topic: Prompt for decision on refresh from database

Wed, 17 Dec 2008 23:18:51 GMT

Topic Description: In the designer, when invoking the "Refresh from database" command, it would be great to be presented with a dialog displaying the new schema changes detected, and by default, all changes are set to "Accept". The user would then be able to optionally make changes to the selections, then press the OK button to apply the changes to the project.

Thanks!

Thomas

Replies: 1
Last Reply: Wed, 17 Dec 2008 23:18:51 GMT
Reply By: Ish Singh

Topic: Designer - Context menu to generate C# code on selected table(s)

Fri, 12 Dec 2008 10:04:34 GMT

Topic Description: I may be doing something incorrectly, but I've noticed on my system that if only a single table has the checkbox column checked, and "Generate C# Classes" is clicked, then no joins are generated for any related tables in the grid that do not have the checkbox checked. This makes sense, since that column is acting as a "include in your object schema" filter. However, a common scenario is that a change has been made to a single table's schema, and one wishes to update the base class for the corresponding object. Under this model, one has to re-generate code for at least that table plus all related tables (less tedious in the UI to just regenerate all). When working with with a large database schema, the generation time of the entire project can potentially take a bit long in programmer's time ; ) As a time-saving measure, it would be handy to be able to generate code for tables that are atomically selected via row selection (as opposed to checkbox selection). One way to implement such a feature might be to label the checkbox column as "Include in Schema", then provide a context menu for "Generate Base Classes for Selected", where the user has selected one or more tables they wish to refresh using traditional click + <SHIFT> or <CTRL> selection.

Thanks,

Thomas

Replies: 1
Last Reply: Fri, 12 Dec 2008 10:04:34 GMT
Reply By: Ish Singh

Topic: Designer - Refresh from Database Shortcut Key and Button

Wed, 10 Dec 2008 00:08:23 GMT

Topic Description:

Couple of thoughts about streamlining the refresh process from inside of the QO designer:

Would be nice to be able to hit <F5> at any point, and have the designer refresh schema from the database.
Would also be cool to have a "Refresh" button on the toolstrip, instead of needing to go into the File menu.

Thanks!

Thomas

Replies: 1
Last Reply: Wed, 10 Dec 2008 00:08:23 GMT
Reply By: Ish Singh

Topic: V4 Designer - Drag and Drop file into Designer

Mon, 08 Dec 2008 03:12:16 GMT

Topic Description: The new v4 designer is really nice. Would be great though to be able to drag and drop a *.qos file into it for quick loading.

Thanks,

Thomas

Replies: 1
Last Reply: Mon, 08 Dec 2008 03:12:16 GMT
Reply By: Ish Singh

Topic: BaseField.SetSort method

Thu, 04 Dec 2008 22:05:50 GMT

Topic Description: I know it is only really saving one line of code, but I think it would make it nicer looking code if you could do this:

 
SomeObject.FieldtoSort.SetSort(1, Akal.QuickObjects.ObjectBase.SortTypes.Ascending)

instead of

 
SomeObject.FieldtoSort.SortPosition = 1  

SomeObject.FieldtoSort.Sort = Akal.QuickObjects.ObjectBase.SortTypes.Ascending

It is really more noticable when you have multiple fields you are sorting on so instead of each field having two lines of code to set up sort on it you only need one.

Just my two cents :)

Mike

Replies: 4
Last Reply: Thu, 04 Dec 2008 22:05:50 GMT
Reply By: Ish Singh

Topic: Data Source Designer - taskbar icon

Thu, 13 Nov 2008 16:24:35 GMT

Topic Description: When the QO Data Source Designer is open, it displays as a separate item on the taskbar, and uses the Visual Studio icon. It may be a better idea to use a unique icon, so as not to give the impression that an additional instance of VS is open.

Thanks,

Thomas

Replies: 1
Last Reply: Thu, 13 Nov 2008 16:24:35 GMT
Reply By: Ish Singh

Topic: GetObjectByPK

Mon, 20 Oct 2008 18:30:59 GMT

Topic Description: Hey all,

I think it would be handy to have a function like this:

Public Function GetCustomerByPK(ByVal ID As GuidField) As Customer
    For Each objCustomer In Me.GenericList
        If objCustomer.CUST_ID.Value = CUST_ID.Value Then
            Return objCustomer
        End If
    Next
    Return Nothing
End Function

Greetings,
Sigurd

Replies: 1
Last Reply: Mon, 20 Oct 2008 18:30:59 GMT
Reply By: Victor Gavriluk

Topic: Designer improvements

Mon, 17 Nov 2008 21:47:37 GMT

Topic Description: Hey all,

I have some ideas to improve the designer a bit or at least make it more user friendly.

When changes are made to the options, you have to press 'Apply' before saving the changes. This could actually be removed and always apply changes before saving. I see no use to apply changes without saving them.
Enhance the template grid so all of the templates are visible at the same time. This list could even be put in a seperate form (docking?), because 99% of the time, you don't need it.
Most of the options need to be set only once at the beginning a new project. So, a wizard would be very handy here. After finishing this wizard, these options should be available on a seperate form (docking?).
The tooltips are very nice, but disturbing. They are too big, sometimes they popup and I can't see what's behind them. This is confusing and sometimes frustrating. Instead of using tooltips, use a seperate dock (bottom or so) and place the help text there. This way it is always visible and user who don't want to see it can hide or close it.
A descent menu and toolbar. CTRL+S and CTRL+O will already be added in latest release which will help a lot already, but more work is needed. At startup of the Designer, it would be nice to show a list of the recent projects, kinda like Visual Studio. This would reduce the number of clicks even more.
Generating the code goes fast, but it always generates ALL objects. Provide a way to select what objects should be generated. It would be very handed to get a notification (or a visible sign) which objects are new and which objects will be overwritten.

Another point that I find annoying is the shortcut to the website being placed on the desktop. Also the sample folder shortcut shouldn't be there. Perhaps you can add this as an option to the installer so everybody can chose this for own use.

Greetings,
Sigurd

Replies: 4
Last Reply: Mon, 17 Nov 2008 21:47:37 GMT
Reply By: Ryan Aljets

Topic: Concurrency management columns

Mon, 29 Sep 2008 23:41:17 GMT

Topic Description: First of all I want to thank you for such a great product and fast support. I have a feature request for the designer app. I think it would be great if designer allowed us to specify what fields should/should not be included in the concurrency check. I know I can do this in code but being able to just set the default in designer will be great.

Another idea we had was to be able to specify columns that are automatically updated. We add a CreateDate and ModifiedDate columns to each table. It would be great if we could specify in the Designer and have the objects automatically update the ModifiedDate on each update and only insert the CreateDate.

Btw, we love the easy template configuration capability. Is there any documentation on how we can create custom templates?

Replies: 4
Last Reply: Mon, 29 Sep 2008 23:41:17 GMT
Reply By: Sigurd Decroos

Topic: Custom Find calls from DataSource

Wed, 09 Jul 2008 19:23:22 GMT

Topic Description: not sure if this is possible, and if it is how difficult it would be...

Right now the Akaltech DataSource control only works with the "Find" and the "Load" methods on the objects.

we have already written many "custom find" calls on our objects. I am just wondering if it would be useful to be able to have the DataSource be able to call any mehtods on the object it finds that returns a dataset? I guess the DataSource could go through the object's methods using reflection and find calls that return datasets and list them in a drop down, and then if those methods are looking for any values to be passed in to allow those to be specified.

Just a wild idea... :)

Mike

Replies: 2
Last Reply: Wed, 09 Jul 2008 19:23:22 GMT
Reply By: Mike Hamilton

Topic: Method on fields that can be used to quickly set list of values for criteria.

Tue, 24 Jun 2008 22:58:55 GMT

Topic Description: I would like to request that a method be added to the field types to make it easy to specify list of values in the criteria.

I could add an extension method myself. But I think it will be nice if you can add a method to the field types. Then we could simply do something like

orders.CustomerID.SetList("1,2,3"); 

This would automatically set the orders.CustomerID.SearchMode to SearchModes.List rather than us having to do it.

It will reduce the code by another three lines!

Wendy

Replies: 1
Last Reply: Tue, 24 Jun 2008 22:58:55 GMT
Reply By: Ish Singh

Topic: Ability to change class names and create multiple classes per table?

Fri, 13 Jun 2008 20:29:20 GMT

Topic Description: Ability to chance class name in designer just like I can specify Alias for column will be great.

And ability to split a table into multiple classes will be a nice feature. In our project we have one table that contains various thing for a plan and based on plan type we only view/update certain fields everything else is simply ignored. Right now I use the code like below:

if (planType.PlanTypeCode.Value == 1) 
{ 
    plan.SetDisplayFields(true, plan.StartDate, plan.EndDate, plan.NotifyType.SendFrom, plan.NotifyType.SendFromName, plan.RequiresResources); 
} 
else if (planType.PlanTypeCode.Value == 2) 
{ 
    plan.SetDisplayFields(true, plan.StartDate, plan.EndDate, plan.NotifyType.SendFrom, plan.NotifyType.SendFromName, plan.NotifySup, plan.NotifySys); 
} 
etc... 

I use same type of code for Update too. The code is no problem and works fine even updates with concurrency check work ok but if I could create classes like PlanType1 and PlanType2 etc that actually map to plan that will be great.

Javier

Replies: 1
Last Reply: Fri, 13 Jun 2008 20:29:20 GMT
Reply By: Ish Singh

Topic: Money/Currency field OR improved parsing on Decimal field

Thu, 12 Jun 2008 18:37:42 GMT

Topic Description: We have a column set as Money in SQL 2005 and the designer mapped this to DecimalField object.

The issue we had was when we did (ex. InvoiceItem.Purchase_price.Parse(txtPurchasePrice.text) it would error if the text had a dollar sign in it.

For now we just did ( InvoiceItem.Purchase_price.Parse(txtPurchasePrice.text.Replace("$",string.empty))

The parse handles commas in the string fine. Example: "$1,050.99" after replacing the dollar sign and passed to InvoceItem.Purchase_Price.Parse as "1,050.99" would parse it into a decimal successfully.

So I feel a MoneyField might be a little overkill, but maybe just support better parsing when a dollar (or any currency character) is in the passed string.

Mike

Replies: 1
Last Reply: Thu, 12 Jun 2008 18:37:42 GMT
Reply By: Ish Singh

Topic: SQL ce 3.5 support

Wed, 14 May 2008 18:49:27 GMT

Topic Description: Does the product currently support using SQLce as a database provider? If so how do you do that.

Thanks,

Mike

Replies: 4
Last Reply: Wed, 14 May 2008 18:49:27 GMT
Reply By: Ish Singh

Reply: Re: Ability to specify alias/property name for constraints

Tue, 10 Nov 2009 20:27:51 GMT

Hello Ryan,

Thank you for your feedback. I think this is very useful idea. We will try to include this in the next minor release scheduled for Q1 2010.

Victor
Quick Objects Support

Reply: Re: Be able to define "base" timezone for autoconversions

Sat, 28 Mar 2009 19:39:15 GMT

Mike,

Thank you for the suggestion. We should be able to get this added in the v5.

Thanks,
Ish

Reply: Re: Limit what items are loaded by designer

Sat, 28 Mar 2009 19:37:18 GMT

Ryan,

Thank you for the suggestion. We'll try to add selective loading of tables/views/procs in the v5 if not we'll get it included in a minor update after v5.

Thanks,
Ish

Reply: Re: ROWLOCK

Sat, 07 Mar 2009 00:40:29 GMT

Hi Sigurd,

It has been added to our feature requests and hopefully this will make it into the next major version.

Thanks,
Ish

Reply: Re: Tracking commands in transaction

Mon, 23 Feb 2009 12:38:44 GMT

Thanks for the suggestion. I can see how this will be useful.

This has been added to request list.

Thanks,
Ish

Reply: Re: Another over load for BaseField.IN

Mon, 23 Feb 2009 12:37:07 GMT

Thanks for the suggestion. Two options are there for implementing this:

1. The In method runs a Find and creates a list of values which is used in the SQL. (as you suggest)
2. The In method indicates to business object that you like to create a subquery to be used with the IN clause.

This feature request is now in our list, and most likely we'll be able to provide both options.

Thanks,
Ish

Reply: Re: How about generating an Enum of field names?

Sun, 08 Feb 2009 13:07:12 GMT

Hello

Thanks for the suggestion. I have logged this feature request.

Best Regards,
Victor

Quick Objects Support

Reply: Re: Ability to open containing folder from QO Designer

Thu, 29 Jan 2009 14:15:48 GMT

This has been added to our request list.

Thanks,
Ish

Reply: Re: Asynchronous Patterns

Tue, 13 Jan 2009 15:23:30 GMT

Hey,

Count me in for this request. This would be a major advantage for webservices and smartclient applications.

Greetings,
Sigurd

Reply: Re: Asynchronous Patterns

Wed, 24 Dec 2008 15:46:52 GMT

HI Thomas,

We have async data fetching in our wish-list. At this point, I am not sure when we can get this implemented but this is something we are considering adding to QO.

Thanks,
Ish

Reply: Re: Prompt for decision on refresh from database

Wed, 17 Dec 2008 23:18:51 GMT

This feature has been in our list for a while and since no one was asking for it, we just let it sit by. Being able to see the changes is certainly going to be very useful. I will check in and see what will it take to get this completed.

Thanks for the great feedback!
Ish

Reply: Re: Designer - Context menu to generate C# code on selected table(s)

Fri, 12 Dec 2008 10:04:34 GMT

Hi Thomas,

This feature is planned and will be included in near future. You can see another discussion with a similar request here. The actual implementation we are going to release is going to be very similar to what you have described. Btw, you can already use <SHIFT>/<CTRL> combination to select multiple table rows (and then set the common properties on them). The same applies to the columns as well.

Thanks,
Ish

Reply: Re: Designer - Refresh from Database Shortcut Key and Button

Wed, 10 Dec 2008 00:08:23 GMT

Good suggestion, will be included in next release. Believe it or not, just a day ago I was thinking of this as well!

:-)
Ish

Reply: Re: V4 Designer - Drag and Drop file into Designer

Mon, 08 Dec 2008 03:12:16 GMT

Thanks for the suggestion, this is already done and will be part of the next release.

Thanks,
Ish

Reply: Re: BaseField.SetSort method

Thu, 04 Dec 2008 22:05:50 GMT

Mike,

I will make a note of the "See also" and make sure we update the documentation to guide the user better. We are soon going to launch a KB on our website that will help us serve our customers better by sharing a lot of how tos/tips/tricks etc.

Thanks for the suggestions, and keep them coming as they help everyone!
Ish

Reply: Re: BaseField.SetSort method

Thu, 04 Dec 2008 17:22:54 GMT

ahhh another place I forgot to look. I looked at the basefield documentation as I was working with a field, didnt think to check the object itself. Keep leanring more and more.

I guess now my feature suggestion would be more "See Also" sections and more details in places in the documentation. ie on the base field methods where it lists the .Set method should list it does more than just the one use. (I personally think this is bad having such a general method that can effect so much different parts of the field object, IMHO, and would be better with different ones ie SetSeach, SetSort, etc but then again also just MHO) And then the .Set overload information page should have a see also to the object .SetSortPosition information page.

But thanks for pointing that out for me. keeping seeing more and more how full featured the framework is.

Mike

Reply: Re: BaseField.SetSort method

Thu, 04 Dec 2008 00:38:39 GMT

Mike,

You can also use the SetSortFieldPositions method on the business objects. You can pass in any number of field instances, and their sort order is set. I am including couple of example below:

customer.SetSortFieldPosition(False, customer.CustomerSince, customer.FirstName, customer.LastName) 
 

If any of the fields already don't have their Sort property set, then they will be set to Ascending. So it makes it very easy to specify sort fields in the order you want. You can also include fields from other related objects as well.

customer.SetSortFieldPosition(False, customer.CustomerID_Orders_Child.OrderAmount, customer.FirstName, customer.LastName) 
' But we want that the OrderAmount should be descending 
customer.CustomerID_Orders_Child.OrderAmount.Sort = Akal.QuickObjects.ObjectBase.SortTypes.Descending 
 

Hope this helps.
Ish

Reply: Re: BaseField.SetSort method

Wed, 03 Dec 2008 18:06:51 GMT

OOPS! another post before I finished research enough!

Never mind! I see the .Set method on fields accepts these two parameters on one of its overloads. I had done just a quick check of the documentation before posting but not enough as I saw the description on the BaseField Methods page listing .Set as
Overloaded. Set method allows you to set the following properties quickly:

Operator
SearchCondition

and only after posting did I look at the actual page for that mthod and see that one of the overloads does what I was looking for.

Cross that request off as "DONE (already there)" LOL

Mike

Reply: Re: Designer improvements

Mon, 17 Nov 2008 21:47:37 GMT

I tried generating code for multiple templates and it works but I do see the funny behavior. I think it would be great to have a log window. Seperate progress bars for each template being generated would be helpful too.

I am now working on a much bigger project so #6 will be certainly useful. Also, when doing a refresh from the database some indication of which tables/columns are new would be helpful.

Ryan

Reply: Re: Data Source Designer - taskbar icon

Thu, 13 Nov 2008 16:24:35 GMT

We will include this in the next release.

Thanks,
Ish

Reply: Re: GetObjectByPK

Mon, 20 Oct 2008 18:30:59 GMT

Hello Sigurd,

I think this best handled using a custom template. I give a link to sample custom template that produce this method for your project.
Download Sample template

To generate code simply add template in Quick Objects Designer project:
Template Configuration Screenshot

Regards,
Victor

Quick Objects Support

Reply: Re: Designer improvements

Fri, 03 Oct 2008 19:54:29 GMT

I like the #6 the most. I had sent a similar request some time ago and I got a response saying that it is already planned to be included in near future.

Sometime back Ish told me that I could have the designer generate code for multiple templates at the same time. The simultaneous code generation works great but the status bar acts funny. It would be nice to have status/log type window that shows what is being generated, and there can be multiple windows open for each separate template being run.

Another suggestion I have is to be able to specify if I want to support WCF and/or Web Services rather than generating these attributes by default. It requires the developer to add a reference to System.Runtime.Serialization even if they are never going to use WCF.

Just my two cents....
Scott

Reply: Re: Designer improvements

Thu, 02 Oct 2008 06:37:34 GMT

I have been using Quick Objects for about a month and have a few suggestions for the designer. Also just want to share my views on the items proposed by Sigud.

1. I like the 'Apply' button. Its just a personal preference and its a good way of making sure that the user intentionally made changes.
2. I haven't needed the template grid at all but I can see a use for being able to see all the templates at once.
4. I found tooltips information to be very helpful as I was getting started and don't have much of a need for them anymore. May be this could be a setting in the application/configuration so the tool tips could be enabled/disabled.

Now my suggestions:
I think the primary key column should be highlighted in the columns grid. Some sort of icon indicating that the column is or part of primary key will be very helpful. If you can do the same for foreign key columns as well that will be perfect.

The other thought I have is about being able to run code generation for more than one template at the same time.

Ryan

Reply: Re: Designer improvements

Tue, 30 Sep 2008 19:11:24 GMT

Hey Sigurd,

Thanks for taking the time to post and share your ideas. I am putting my thoughts below:

"Apply" button has been there since the first release of the product and essentially it is there to protect from any accidental change in the settings. Any change to settings can alter the way code is generated and could result in unexpected behavior.
We'll dicuss the template grid further internally and get back on that.
If a few more customers like the idea of a Wizard then we'll be certain to add that. As far as a seperate form and docking is concerned you can currently pin/unpin the pane with project and table properties and dock it at the top or left if you like.
We'll certainly do something about the tooltips soon. The tooltips however can be closed by a left mouse click.
CTRL + S and CTRL + O are already functioning in 4.2 give that a try ;) Start up page like Visual Studio is a good idea and I have added that to feature requests. Also it would be nice if you can explain what you mean by decent menu/toolbar.
Generating code for selected objects I think will be a very useful feature. We did get the same request earlier from couple of customers as well and we already have the plumbing in place for implementing this. We hope to have it in the next minor upgrade release. I am not sure I understood what you meant to say by "which objects are new and which objects will be overwritten" but so far QO Designer has always overwritten any file it generates and we have only recommended that create all your customizations in a seperate file and use a "partial" class definition to ensure that your customizations are not overwritten.

I'll put this in feature requests and we'll probably make this an option in the installer. This is truly a personal preference thing as long back we received couple of requests saying installer should put a shortcut on the desktop.

In general our focus has always been on improving the framework and the generated code as that is what the developers spend most of the time with.

Also, I want you to know that we really appreciate you taking the time to share your thoughts/suggestions with us. In end result the product improves and everyone benefits so we are always open to feedback (public or private).

Thanks,
Ish

Reply: Re: Concurrency management columns

Mon, 29 Sep 2008 23:41:17 GMT

Well Wendy,

I know why they are so fast implementing new features. They have a new bastxxx customer who is very high demanding and pushing them like hell... Me :)

Honestly, I've been a lot in contact with Ish (almost daily for the past 30 days) to improve QO and make it even more user friendly and powerfull (validation, errorprovider, ...). He's an amazing guy and very helpfull finding solid solutions. I'm sure QO will only become better in the future thanks to him and his team.

Greetings,
Sigurd

Reply: Re: Concurrency management columns

Thu, 25 Sep 2008 17:53:37 GMT

This is great news! I installed QO 4.2 this morning and perfect, now I can tell the designer which fields should/should not be include in concurrency.

Next I'll try the template that you have suggested.

I am just amazed how fast you guys turn around with features! How do you do it? :)

Reply: Re: Concurrency management columns

Wed, 24 Sep 2008 22:30:39 GMT

Hi Wendy,

We have taken care of your request in 4.2 release. The designer now allows you to choose what fields will allow concurrency check.

As far as CreateDate and ModifiedDate are concerned, along with the installed template you can see there are two more templates called

EventCapture_Table_Name.cs.template
EventCapture_Table_Name.vb.template

Both these templates in C# and VB.Net demonstrate how you can capture the BeforeUpdate, AfterUpdate, BeforeInsert and AfterInsert events and do something specific there. In your case it will be making sure that the CreateDate gets a default value and is included during insert and while modified date gets a value and included in update.

You can also override the Insert, Update and Delete methods if you prefer, but then you will be required to enforce the security of the objects as well. If you use the events, they are only fired if the user does have permission (in case you are using the Permission provider).

Hope this helps but if you need any further information or help please let us know.

Thanks,
Ish

Reply: Re: Concurrency management columns

Fri, 05 Sep 2008 22:11:01 GMT

Wendy,

Thanks for the feedback, feature request and sharing your idea. Your ideas are great and I can see these being used by a lot of people. At this point the CreateDate and ModifiedDate type scenario can be easily handled with a custom template and generating a second set of partial classes. I'll be sure to upload a template showing how to do that. We don't have any other documentation on how to create custom templates yet, that is in our roadmap. But templates aren't that difficult to do, and the best way would be to open up a copy of any of the existing templates in Visual Studio (or another editor) and start modifying it. In fact we edit our templates in VS!

The other feature request about specifying concurrency management columns is very useful as well and we'll surely try to include that in the next release.

Again thanks for the great feedback, please keep it coming as thats what goes into the product :)

Best Regards,
Ish

Reply: Re: Custom Find calls from DataSource

Wed, 09 Jul 2008 19:23:22 GMT

So basically we have to add the attribute shown to the functions we want available (all) and then the datasource should see them?

Cool! will check it out when we can.

Mike

Reply: Re: Custom Find calls from DataSource

Wed, 09 Jul 2008 00:35:44 GMT

Hi Mike,

What if I say it is already very much possible ;) The functionality you are describing is already available in the ObjectDataSource (native ASP.NET component) and Quick Objects based classes already support ODS.

So lets say you create a method on your "Customers" class called GetOrdersByID and it takes a string as a parameter and returns a DataSet or something else. You can simply use the ObjectDataSource and specify the class "Customers" (and it should already be listed there as we have done the ground work to support ObjectDataSource) and choose the method on the next step, and set parameter values on the third step.

Here is sample code for the method and it shows the attribute you will need to apply to your custom methods for them to be usable by the ObjectDataSource.

    <System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, True)> _ 
    Public Function GetOrdersByID(ByVal ID As Integer) As DataSet 
        Me.ObjectMode = ObjectModes.Search 
        Me.Join_CustomerID_Orders_Child() 
        CustomerID_Orders_Child.CustomerID.Value = ID 
        Return CustomerID_Orders_Child.Find() 
    End Function 
 

Here are the three screenshots of the three steps involved.

Step 1: Choose Business Object

Step 2: Choose Method (Marked with DataObjectMethodAttribute)

Step 3: Set Parameter Values or Source

Let us know if you need any further clarification or help.

Ish

Reply: Re: Method on fields that can be used to quickly set list of values for criteria.

Tue, 24 Jun 2008 22:58:55 GMT

Wendy,

This is a great request. We'll try to add it to our next release which hopefully will be ready for beta in another week or so and will include support for multi databases and LINQ.

I think we will name the method In and the syntax will be like this:

orders.CustomerID.In(1,2,5); 
orders.OrderDate.In(dateTime1,dateTime2); 

I'll add points to your account and if you have any other requests or suggestion don't hesitate!

Thanks,
Ish

Reply: Re: Ability to change class names and create multiple classes per table?

Fri, 13 Jun 2008 20:29:20 GMT

Javier,

Thanks for the feature requests. As far as the first one is concerned, that is easy to add and most likely will make it into the next release.

As far as the second is concerned, it is also doable and we have experimented with similar thing in the past. At this time I am not sure if this will make into this coming release but will let you know once I have a better handle on that.

Thanks,
Ish

Reply: Re: Money/Currency field OR improved parsing on Decimal field

Thu, 12 Jun 2008 18:37:42 GMT

We'll enhance the Parse method to handle different currency formats in the coming version.

Thanks,
Ish

Reply: Re: SQL ce 3.5 support

Wed, 14 May 2008 18:49:27 GMT

Hi Ankur,

Sync will not be automatic and it will not be done by Quick Objects (at-least no plans as of now). Syncronization can be done using the RDA protocol, and can you can take a look at the following two articles to get started:

Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET

Configuring Internet Information Services for SQL Server 2005 Compact Edition Remote Data Access and Merge Replication

Thanks,
Ish

Reply: Re: SQL ce 3.5 support

Wed, 14 May 2008 18:40:03 GMT

Hi Mike,

I would like to clarify Victor's response further:

We will be supporting SQL CE 3.0 and 3.5 on Desktop and Windows CE using Compact Framework in the next release. Quick Objects Designer will be extended to support the sql ce running on the desktop only though. So if you plan on using CE on compact framework you will still need to have a compatible copy of database either in CE or SQL Server accessible from your desktop.

We currently have the MySQL 5, SQL CE 3.X working with our DB Library already, and we have begun work on supporting these databases in the Business Logic Framework and Designer. Target release date is end June, but if you want we can provide you a beta version by end of May.

Let us know if you have any further questions.

Thanks,
Ish

Reply: Re: SQL ce 3.5 support

Wed, 14 May 2008 05:23:59 GMT

dear sirs, we are trying ur code generator and we want use also for pocket pc app. you say to make available june end but i want know if u make it faster?

we using cf and sqlce 3.5. also i want know if it sync automaticaly to server or how we make it?

Reply: Re: SQL ce 3.5 support

Tue, 13 May 2008 19:53:55 GMT

Current version of Quick Objects do not support compact framework. We planning on adding support for CF2 or later in next version along with MySQL.

I know we got DBLibrary already working but I think we have one limitation with code generation and will need SQL 2005 database or other db to generate code. I am not sure at this time. And we only planning to support SqlCE 3 or later.

Next version release target June end but if you need it early or want beta tell us.

Regards,
Victor